SQL = "INSERT INTO
in [JavaScript]
|
From: Rob Christiansen on 16 Apr 2010 16:59 OK, something strange is going on here. You replied to my question, (thanks) but when i opened your response i got an earler question. i was trying to post using a thread. Apparently i'm not doing it correctly. So here it is agtaIN, no thread .. I get a lot of "data type mismatch" error messages. The problem as i see it is, the mbd file is composed mainly of type-text fields, but there're 2 type-currency fields and 1 type-date field. The software is apparently having trouble reading the different types. You fixed date-field, but what about the 2 floats, fdebit and fcredit? Don't those have to be treated specially? .. fdate is set as "date/time" type fdebit is set as "currency" type fcredit is set as "currency" type fprevrec and fnextrec are number type newid is set as "auto" type all the rest are "text" type .. var SQL = "INSERT INTO books1 VALUES( "+ newid + "," + fprevrec + "," + fnextrec + ",'" + fforegrnd + "','" + fbackgrnd + "','" + fyear + "','" + fmonth +"','"+ fbank + "','" + finitials + "','" + ftype + "','" + fcheck + "',#" + fdate + "#,'" + fdescription + "'," + fdebit + "," + // <-------------------------------- fcredit + ",'" + // <-------------------------------- fproject + "','" + fmsc1 + "','" + fmsc2 + "','" + fmsc3 + "','" + fmsc4 + "','" + fmsc5 + "','" + fmsc6 + "')"; // crazyswede *** Sent via Developersdex http://www.developersdex.com ***
From: Jeff North on 16 Apr 2010 21:12 On 16 Apr 2010 20:59:04 GMT, in comp.lang.javascript Rob Christiansen <robb_christiansen(a)q.com> <4bc8cf98$0$87070$815e3792(a)news.qwest.net> wrote: >| >| OK, something strange is going on here. You replied to my question, >| (thanks) but when i opened your response i got an earler question. i was >| trying >| to post using a thread. Apparently i'm not doing it correctly. So here >| it is agtaIN, no thread >| . >| I get a lot of "data type mismatch" error messages. The problem as i see >| it is, the mbd file is composed mainly of type-text fields, but there're >| 2 type-currency fields and 1 type-date field. The software is apparently >| having trouble reading the different types. You fixed date-field, but >| what about the 2 floats, fdebit and fcredit? Don't those have to be >| treated specially? >| . >| fdate is set as "date/time" type >| fdebit is set as "currency" type >| fcredit is set as "currency" type >| fprevrec and fnextrec are number type >| newid is set as "auto" type >| all the rest are "text" type >| . >| var SQL = "INSERT INTO books1 VALUES( "+ >| newid + "," + >| fprevrec + "," + >| fnextrec + ",'" + >| fforegrnd + "','" + >| fbackgrnd + "','" + >| fyear + "','" + >| fmonth +"','"+ >| fbank + "','" + >| finitials + "','" + >| ftype + "','" + >| fcheck + "',#" + >| fdate + "#,'" + >| fdescription + "'," + >| fdebit + "," + // <-------------------------------- >| fcredit + ",'" + // <-------------------------------- >| fproject + "','" + >| fmsc1 + "','" + >| fmsc2 + "','" + >| fmsc3 + "','" + >| fmsc4 + "','" + >| fmsc5 + "','" + >| fmsc6 + "')"; // >| crazyswede Does this error only occur when the description has an apostrophe? Are you sending the fdebit and fcredit values through unformatted i.e. 1234.56 not 1,234.56?
From: Garrett Smith on 17 Apr 2010 18:53 Rob Christiansen wrote: > OK, something strange is going on here. You replied to my question, > (thanks) but when i opened your response i got an earler question. i was > trying > to post using a thread. Apparently i'm not doing it correctly. So here > it is agtaIN, no thread > . This appears as a disconnected thread post about SQL. It is inappropriate to post this to a usenet newsgroup "comp.lang.javascript". There are cases wher SQL can be used in the browser, with javascript, however, after reading this example, it appears that this is not one of them. > *** Sent via Developersdex http://www.developersdex.com *** I suggest not using that to post to usenet. -- Garrett comp.lang.javascript FAQ: http://jibbering.com/faq/
|
Pages: 1 Prev: database Next: FAQ Topic - How can I disable the back button in a web browser? (2010-04-17) |