david7777777777
Programmer
I've been reading ASP, JavaScript, VB, Remote Scripting, and InterDev. To try to learn all this at once might have been a bad idea, but I'm too far into it to quit now. Anyway, I've read and re-read and re-read the posts on Tek-Tips and Microsoft's pages on Remote Scripting. Although they seem to explain it well and spell it out, I don't yet know enough to be able to take what they are telling me and apply it to my project. I'm going to post what I'm working on (a simple example) and see if one of you could provide me with the exact code that I need to make it work, then I can understand how to apply remote scripting to my entire project.
I've got a SQL 2000 database running on Windows 2000 Server, I'm using InterDev 6 SP-5 making ASP pages to build user interface pages that allow users to view, add, edit, delete records in the database. I'm trying to keep the functionality as simple as possible.
What I really don't understand about remote scripting is the part about exposing your routines as methods or something like that. I understand about the little tags you have to have on your client and server pages to make remote scripting work and all. I'm also still learning JavaScript so I'll get that part eventually.
I'll describe a simple example of what I'm trying to do.
On the client page I've got:
Textbox: txtName, which is used to enter the last name of an employee.
Button: btnSearch, which is pressed to invoke the SQL and the Record Set on the server page, which is set to return the matching employee's record(s) and display them in an editable grid. The editable grid works great, thanks Merlin.
On the server page I've got:
Record Set: rsEmployee, set with SQL to retrieve its search parameter (Last Name) from the client page txtName
Grid: grdEmployee, used to display the matching record(s)
By the way, this all works flawlessly on one single page. I just need to figure out the code to make it work between two pages because there are things I want to do that don't work well if I cram everything onto one page. It's sloppy. I think that's all I need to tell you for now. Any advice, pointers to articles, code bits is greatly appreciated.
I've got a SQL 2000 database running on Windows 2000 Server, I'm using InterDev 6 SP-5 making ASP pages to build user interface pages that allow users to view, add, edit, delete records in the database. I'm trying to keep the functionality as simple as possible.
What I really don't understand about remote scripting is the part about exposing your routines as methods or something like that. I understand about the little tags you have to have on your client and server pages to make remote scripting work and all. I'm also still learning JavaScript so I'll get that part eventually.
I'll describe a simple example of what I'm trying to do.
On the client page I've got:
Textbox: txtName, which is used to enter the last name of an employee.
Button: btnSearch, which is pressed to invoke the SQL and the Record Set on the server page, which is set to return the matching employee's record(s) and display them in an editable grid. The editable grid works great, thanks Merlin.
On the server page I've got:
Record Set: rsEmployee, set with SQL to retrieve its search parameter (Last Name) from the client page txtName
Grid: grdEmployee, used to display the matching record(s)
By the way, this all works flawlessly on one single page. I just need to figure out the code to make it work between two pages because there are things I want to do that don't work well if I cram everything onto one page. It's sloppy. I think that's all I need to tell you for now. Any advice, pointers to articles, code bits is greatly appreciated.