As far as I could understand when experimenting with Access the SQL language accepted by Access is limited. Thus you can not say
select username,password from users All you can say instead is only select * from users Similarly select count(*) may also be forbidden. I am not sure if your question was regarding such aproblem, but this may really be an issue. I faced it when I tried to debug the ODBC module of ScriptBasic using Access, but I have never read this in documentation. Regards, Peter -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rafferty Uy Sent: Friday, March 22, 2002 10:24 AM To: ActivePerl Mailing List Subject: Database access Hello there, How can I retrieve the data I got from my sql queries to my MS Access Database? If for example i queried sql("select count(username) from users where username = " $strUsername); how can i get the count value? and is my understanding of the sql() correct? I can't understand the documentation very well and how can i get the data if my sql query retrieves a table of data? sql("select * from users"); or sql("select username,password from users"); Thanks in advance Rafferty _______________________________________________ ActivePerl mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
