Sign in to follow this  
Followers 0
gcue

help with quotes

5 posts in this topic

i am inserting values from a text file into a sqlite database.

first i create the array then cycle through each array record and insert it into a sql table.

For $y = 0 To UBound($avOut) - 1
     $aTemp[0] = "'" & $avOut[$y][0] & "'"
        $aTemp[1] = "'" & $avOut[$y][1] & "'"
        $aTemp[3] = "'" & $avOut[$y][3] & "'"

        $sTemp = $aTemp[0] & "," & $aTemp[1] & "," & $aTemp[3]

        _SQLite_Exec(-1, "INSERT INTO aAssetInfo (Tag,Status,Type) VALUES (" & $sTemp & ");")
Next

the problem i am running into is when a data field has a single quote, then that record is not inserted. how should i specify the quotes here

"'" & $avOut[$y][0] & "'"
to get around that?

thanks in advance!

Share this post


Link to post
Share on other sites



I still haven't got around to trying these functions. Anyway a quick Google search brought me to this page. I don't know if it helps.

http://stackoverflow.com/questions/775687/how-to-insert-text-with-single-quotation-sql-server-2005

Share this post


Link to post
Share on other sites

i tried double single quotes but that didnt work for me.

"''" & $avOut[$y][0] & "''"

Share this post


Link to post
Share on other sites

that worked great!

thanks Jos!! =)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0