Devam Ediyor

msAccess corrupted

this is an adult website / must know msaccess and some cold fusion /

this was a working website and the msaccess database seems gotten corrupted - here is the error:

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.

The error occurred in D:\hshome\web2874\[url removed, login to view]\[url removed, login to view]: line 47

Called from D:\hshome\web2874\[url removed, login to view]\[url removed, login to view]: line 26

Called from D:\hshome\web2874\[url removed, login to view]\[url removed, login to view]: line 618

Called from D:\hshome\web2874\[url removed, login to view]\[url removed, login to view]: line 47

Called from D:\hshome\web2874\[url removed, login to view]\[url removed, login to view]: line 26

Called from D:\hshome\web2874\[url removed, login to view]\[url removed, login to view]: line 618

45 : <cfquery DATASOURCE="web287_cendb" USERNAME="Admin">

46 : insert into Orders(CFID,CFTOKEN,invoicenum,email,items,orderdate,shipmethod,paymentmethod,creditcard,expdate,cvv,comment,itemsent,subtotal,taxtotal,shiptotal,ordertotal)

47 : values(#CLIENT.CFID#,#CLIENT.CFTOKEN#,'#newinvoice#','#FORM.email#','#FORM.items#','#DateFormat(Now(),"YYYY-MM-DD")#','#FORM.shipmethod#','#FORM.paymentmethod#','#FORM.creditcard#','#FORM.expdate#','#newcomment#','#DetailMsg#',#subtotal#,#taxtotal#,#shiptotal#,#grandtotal#)

48 : </CFQUERY>

49 :

SQL insert into Orders(CFID,CFTOKEN,invoicenum,email,items,orderdate,shipmethod,paymentmethod,creditcard,expdate,cvv,comment,itemsent,subtotal,taxtotal,shiptotal,ordertotal) values(968413,76909948,'1409050001','star2874@msn.com','CF-35,dvd,1,59.5','2014-09-05','Standard','Mastercard','xxxxxxxxxxxx','11/15','','Part No Title Format Price Disc. Total CF-35 Hard Corps Recruits DVD $59.50 $0.00 $59.50 Product Total $59.50 Order Discount $0.00 Subtotal $59.50 CA Tax $3.87 $63.37 U.S. Shipping $9.50 $72.87 Final Total $72.87 ',59.5,3.86749985814,9.5,72.8674998581)
DATASOURCE star287_cendb
VENDORERRORCODE -3520
SQLSTATE 21S01


this is a shopping cart made in CF - when customer checks out / the customer info is suppose to update in msAccess DB and email is sent to the owner alerting the order has been placed - as you can see - the CF fails to update the msAccess -

Beceriler: ColdFusion, Microsoft Access, Web Sitesi Tasarımı

Daha fazlasını görün: corrupted, jdbc odbc, insert adult, database driver website, error executing database query, client access odbc, microsoft access query design, adult insert, access query design, client access odbc driver, database design microsoft access, 618, access insert, adult email database, email database adult, odbc access, website fusion error, sequelink error, form msaccess, database adult website, access odbc, microsoft access database design, socket database, database access orders, email msaccess

İşveren Hakkında:
( 21 değerlendirme ) Coral Springs, United States

Proje NO: #6513894

Seçilen:

truongngocthanh

Hi Sir, I know this issue, the columns are 17 but the values just 16,i can fix it right now. Please consider. Thanh

2 gün içinde 111$ USD
(53 Değerlendirme)
6.0

3 freelancer bu iş için ortalamada 149$ teklif veriyor

marinkogavran

Hello. I'm highly interesed in your project.. You can see in my reviews that I've done similar projects and customers were satistified.. So why wouldn't you become one of my satistified customers?

1 gün içinde 180$ USD
(10 Değerlendirme)
2.8
vjmakwana

A proposal has not yet been provided

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0
prologix3

Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the resu Daha fazlası

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0