mgordonprincewilliam wrote: > The problem is that I get no returns from the Dbase. I know > my code is really malformed, but I would appreciate someone > showing me how the "objRS.Open "Select..." should look in > order to make this happen, or if I might have to do some > other declarations, if you could show me how that would work > please. I'm very new to ASP, but think I could provide > something nice for the Public to see for our Recreation Department.
It's 4am here, so I am not going to attempt to debug your SQL, but something I find always helps (even at 4am) is to build the sql query in a string prior to opening the recordset and then writing that string out to the response object so I can see it in the browser. Dim sSql sSql = "Select..." 'Remove the following line from the final non-debug version: Response.write sSql objRs.Open sSql,... Even at 4am, if I can't spot the problem in the SQL I can copy and paste it into Access or MySQL or whatever and I'll soon know whether the problem lies in my SQL. If there's nothing wrong with the SQL then that narrows it down to the connection or the call to objRs.Open... Adelle. ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
