tcp-insert - Options? about mysql-r3 HOT 5 CLOSED

Could you give me an example of your sql query? Thanks!

from mysql-r3.

Thanks for the quick reply, (sorry I took so long to check for a reply).
Here is the Rebol Test script:

Rebol [ Title: "Basic mySQL test"]
do %mysql-protocol.r3
Open-DB: mysql://[Username:Password]@[Domain]/[DBName]
db: open Open-DB
; Okay so far - no apparent errors in opening it
QueryStr: "SELECT * FROM Vehicle" ; Get everything from Table called Vehicle
insert db QueryStr
; also tried: insert db QueryStr make object![] as the code seems to suggest that it is expecting an object for options.
;
Table: copy db
close db
Record: first Table
print ["Record type:" type? Record] ; = block (in R2 but errors out before it gets here in R3)

from mysql-r3.

I am on my phone, so I can't check the code, but I dont think you are supposed to call insert on the port directly, but instead you should call send-sql

Gordon Raboud [email protected]编写：

Thanks for the quick reply, (sorry I took so long to check for a reply).
Here is the Rebol Test script:

Rebol [ Title: "Basic mySQL test"]
do %mysql-protocol.r3
Open-DB-Table: mysql://[Username:Password]@[Domain]/[Table]
db: open Open-DB-Table
; Okay so far - no apparent errors in opening it
QueryStr: "SELECT * FROM Vehicle" ; rem At it's simplest form
insert db QueryStr
; also tried: insert db QueryStr make object![] as the code seems to suggest that it is expecting an object for options.
;
Table: copy db
close db
Record: first Table
print ["Record type:" type? Record] ; = block (in R2 but errors out before it gets here in R3)

—
Reply to this email directly or view it on GitHub.

{"@context":"http://schema.org","@type":"EmailMessage","description":"View this Issue on GitHub","action":{"@type":"ViewAction","url":"https://github.com/zsx/mysql-r3/issues/1#issuecomment-60593652","name":"View Issue"}}

from mysql-r3.

发自我的小米手机

Gordon Raboud [email protected]编写：

Thanks for the quick reply, (sorry I took so long to check for a reply).
Here is the Rebol Test script:

Rebol [ Title: "Basic mySQL test"]
do %mysql-protocol.r3
Open-DB-Table: mysql://[Username:Password]@[Domain]/[Table]
db: open Open-DB-Table
; Okay so far - no apparent errors in opening it
QueryStr: "SELECT * FROM Vehicle" ; rem At it's simplest form
insert db QueryStr
; also tried: insert db QueryStr make object![] as the code seems to suggest that it is expecting an object for options.
;
Table: copy db
close db
Record: first Table
print ["Record type:" type? Record] ; = block (in R2 but errors out before it gets here in R3)

—
Reply to this email directly or view it on GitHub.

{"@context":"http://schema.org","@type":"EmailMessage","description":"View this Issue on GitHub","action":{"@type":"ViewAction","url":"https://github.com/zsx/mysql-r3/issues/1#issuecomment-60593652","name":"View Issue"}}

from mysql-r3.

Thank-you! That was it.

from mysql-r3.