Results 1 to 9 of 9

Thread: [2008] Using variables in an SQL string

Hybrid View

  1. Mar 3rd, 2009, 10:07 AM #1
    Redeye44us
    Redeye44us is offline
    Member Redeye44us's Avatar
    Join Date
    Apr 2003
    Posts
    50

    Re: [2008] Using variables in an SQL string

    I am somewhat of a newby, but in the past, I have done it like this:


    strSQL = "UPDATE rate SET count = " + variable + " WHERE ID = 1;"

    I break up the string into parts and insert the variables in between. The variable will need to be converted to a string (variable.tostring).

    Hope this helps!
    Last edited by Redeye44us; Mar 3rd, 2009 at 10:18 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width