Re: Maybe more of a VB question, but here goes

Try:

pg_cn.Execute "INSERT INTO itemlist (.....) VALUES (..., " & Replace(rd!d,
"'", "''") & ", ...)"

Regards, Dave.

> -----Original Message-----
> From: Corey W. Gibbs [mailto:cgibbs(at)westmarkproducts(dot)com]
> Sent: 13 March 2002 18:14
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Maybe more of a VB question, but here goes
>
>
> Good Morning Everyone,
>
> I'm having a bit of a VB problem, and I don't know quite how
> to solve this
> as my VB knowledge is minimal at best. The problem is with
> quotes and
> apostrophes in variables. What I'm doing is pulling some
> really really
> really bad data from an Access database and trying to insert
> it into my
> handy dandy Postgres db.
>
> Here's the insert statement:
> pg_cn.Execute "INSERT into
> itemlist(jobno,area,floor,building,room,elevation,phase,cycle,
> model,w,h,
> d,itemno," & _
> "finish,mtostatus) values('" & rs!jobno & "','" & rs!area
> & "','" &
> rs!floor & "','" & rs!building & "','" & _
> rs!room & "','" & rs!elevation & "','" & rs!phase & "','"
> & rs!cycle &
> "','" & rs!model & "','" & rs!w & "','" & rs!h & "','" & _
> rs!d & "','" & rs!itemno & "','" & rs!finish & "','" &
> rs!mtostatus &
> "')"
>
> rs is an adodb recordset
>
> Now, if rs!d="7'" (I said it was bad data ;)) that tickmark
> throws off the
> whole insert statement. as they're interpreted as the genuine
> ticks. Has
> anyone come across this or can anyone point me in the right
> direction to
> solve this problem short of removing the users "-' key?
>
> thanks in advance
> corey
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>