[REBOL] Re: ODBC
From: ric_shepard:fishgame:state:ak:us at: 9-Dec-2000 14:21
Your 'scrambled' dat is probably the result of passing 'unquoted'
string data to ODBC/ SQL.
what you have: >> firstname: "Joe"
== "Joe"
>> print firstname
Joe
what you need: >> firstname: {"Joe"}
== {"Joe"}
>> print firstname
"Joe"
so, try this:
firstname: {"Joe"}
insert db-port [{INSERT INTO reboltest (fname) VALUES (?)} firstname]
should make all the difference.
Graham Chiu wrote:
> spoke too soon, here the first and fourth inserts work
>
> insertrecs: func [] [
> insert db-port [ {insert into reboltest (fname ) values
> ("GRAHAM" )} ]
>
> firstname: "Joe" dob: 10-Dec-1950
> insert db-port [ {insert into reboltest (fname, birthday)
> values (?, ?)} firstname dob ]
>
> firstname: "Josephine " dob: 10-Dec-1940
> insert db-port [ {insert into reboltest (fname, birthday)
> values (?, ?)} firstname dob ]
>
> insert db-port [ {insert into reboltest (fname, birthday)
> values ("Allen", ?)} to-date "31-Dec-1957" ]
> ]
>
> but where I pass the fname as a variable, I get scrambed
> data back.
>
> --
> Graham Chiu
> --
> To unsubscribe from this list, please send an email to
> [rebol-request--rebol--com] with "unsubscribe" in the
> subject, without the quotes.
-- Binary/unsupported file stripped by Listar --
-- Type: text/x-vcard
-- File: ric_shepard.vcf
-- Desc: Card for Ric Shepard