var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query problem [resolved]
Hi am tring to write a program in VB.net which connects to and excutes some queries, I try to excute the below query and it says something is up with my statement
INSERT INTO calls ( CallID, ContactID, CallDate, CallTime, Callername, Notes, CallerCompany, ActionTakenID, EmployeesID, ShortMessage, CallerNumber, Charged, OperatorID, DDI) Values (1602848, 1398, #17/12/2004#, #15:22:01#, "Not forwarded", "No message", "N/A", 7, 22, "Message For 15:21:55 on 17/12/2004", "Number Withheld", False, 42, "9240")
Have tried the above in Access and it works fine, is MySQL a bit more fussy?
Last edited by oak12; 12-20-04 at 04:52.
Spent hours on this, finally found out stupid mysql likes it's dates like
don't assume access queries will run in mysql
there's a lot more that's different between the two of them than just the format of the sate strings