/    Sign up×
Community /Pin to ProfileBookmark

Mixing ASP and Javascript

Copy linkTweet thisAlerts:
Oct 06.2005

Hi Everybody,

I managed to connect to an Access *.mdb and create recordsets (with ASP). Naturally, the recordsets have several records.

I imagine that once I’ve captured the recordset that I don’t really need to manipulate the set with ASP…. Everything I need can be done on the client.

So! Can I manipulate the recordset with Javascript? By manipulate, I mean just to display the records one at a time so I need the APP to respond to [[COLOR=Blue]First[/COLOR]] [[COLOR=Blue]Next[/COLOR]] [[COLOR=Blue]Previous[/COLOR]] [[COLOR=Blue]Last[/COLOR]] and [[COLOR=Blue]Quit[/COLOR]] buttons.

Any suggestions, or a URL for a tutorial on this?

Many thanks
-Paul-

to post a comment
JavaScript

5 Comments(s) ↴

Copy linkTweet thisAlerts:
@fulton_savageOct 06.2005 — That sounds like a goofy idea--why would you want to transmit an entire record set to the client and process it there instead of doing it on the server and just sending the generated page?
Copy linkTweet thisAlerts:
@jPaulBauthorOct 06.2005 — The recordsets are not all that big.. perhaps never more than 25 or so records.

As I understand it, stepping through each record with ASP would require sending a [I]get statement[/I] to the server, receive a single record, and then sending a new [I]get statement[/I] to the server and so on until a viewer chooses to quit. Seems like a waste.

On the other hand, if the client already knows the whole recordset, then displaying records one by one would be better served [I]ON[/I] the client.

Is that goofy?

Regards,

-Paul-
Copy linkTweet thisAlerts:
@fulton_savageOct 06.2005 — If you're generating a record set in ASP you'll have to step through it to store it in a javascript array regardless. If the recordset is small whats the big deal anyways....
Copy linkTweet thisAlerts:
@jPaulBauthorOct 06.2005 — Whats the big deal?

Jeeez Fulton...

How about some "[I][COLOR=Blue]form of answer[/COLOR][/I]" rather than 'judging' my purpose

-Paul-
Copy linkTweet thisAlerts:
@fulton_savageOct 06.2005 — You got it.

[url=http://www.4guysfromrolla.com/webtech/050901-1.shtml]Paging records on the client[/url]
×

Success!

Help @jPaulB spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.18,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...