Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search


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