[REBOL] Re: ODBC
From: allenk:powerup:au at: 10-Dec-2000 19:51
----- Original Message -----
From: "Graham Chiu" <[gchiu--compkarori--co--nz]>
To: <[rebol-list--rebol--com]>
Sent: Sunday, December 10, 2000 10:06 AM
Subject: [REBOL] Re: ODBC
> On Sat, 09 Dec 2000 14:21:01 -0900
> Ric Shepard <[ric_shepard--fishgame--state--ak--us]> wrote:
>
> > Your 'scrambled' dat is probably the result of passing
> > 'unquoted'
> > string data to ODBC/ SQL.
> >
>
> > so, try this:
> >
> > firstname: {"Joe"}
> > insert db-port [{INSERT INTO reboltest (fname) VALUES
> > (?)} firstname]
> >
> > should make all the difference.
>
> Unfortunately, it makes no difference. The ODBC examples
> are similar to what I have done here.
Have you checked to see if the date format is the same for the database and
your local machine? I've had this problem with databases on servers that are
running in a US time zone, when using ASP. So would assume it is also
possible problem with command.
If you are having trouble using named values like above, why not create the
standard SQL string yourself.
firstname: "Joe"
insert db-port rejoin ["INSERT INTO reboltest (fname) VALUES ('" firstname
')
]
To me this is the beauty of the REBOL/Command odbc interface. A connection,a
command port and SQL. Much simpler than the multiple methods and objects of
ADO.
Cheers,
Allen K