Problems reading integers from table...!

Results 1 to 2 of 2

Thread: Problems reading integers from table...!

  1. #1
    Aspaman Guest

    Default Problems reading integers from table...!

    Hello,<BR>I have a little question...<BR>I execute a query, which has to return a record with 32 attributes.<BR>All of these attributes are strings, except for one, which is an integer.<BR>The query crashes on that one integer... An example:<BR><BR>this works: objRs.Open("select strName, strLastname from table", objConn)<BR>and this doesn&#039;t: objRs.Open("select strName, iNumber from table", objConn)<BR><BR>It crashes directly after that. Can anybody please give an advice? Should I somehow convert that attribute to string, when I execute this query with rs.Open?<BR><BR>Thx,<BR>Aspaman<BR>

  2. #2
    vijay Guest

    Default RE: Problems reading integers from table...!

    select strName, strLastname from table<BR>is a SQL query. You cannot put variables like strName,str...<BR><BR>You need to mention the Coulmn name of the table. No spelling mistakes allowed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts