Forum » Izdelava spletišč » Data type mismatch in criteria expression
Data type mismatch in criteria expression
dekos ::
Kdo mi lahko kaj pomaga glede te napake. Pojavi se namreč le ko je v bazi tabela orders popolnoma prazna, ko pa je v njej že kak podatek pa deluje dodajanje novih podatkov normalno.
Jamra okrog te kode:
orn=OrderNo()
For Each Key in dictCart
SQLstmt = "INSERT INTO orders (sid,orderno,customer,adate,code,qty,price,shipping,shipcode,description,username,card)"
SQLstmt = SQLstmt & " VALUES ("
SQLstmt = SQLstmt & "'" & sid & "',"
SQLstmt = SQLstmt & "'" & orn & "',"
SQLstmt = SQLstmt & "'" & customer & "',"
SQLstmt = SQLstmt & "'" & date() & "',"
SQLstmt = SQLstmt & "'" & key & "',"
SQLstmt = SQLstmt & "'" & dictCart(Key) & "',"
SQLstmt = SQLstmt & "'" & GetItemPrice(Key) & "',"
SQLstmt = SQLstmt & "'" & shipping & "',"
SQLstmt = SQLstmt & "'" & shipcode & "',"
SQLstmt = SQLstmt & "'" & description & "',"
SQLstmt = SQLstmt & "'" & username & "',"
SQLstmt = SQLstmt & "'" & card & "'"
SQLstmt = SQLstmt & ")"
Set RS = conn.execute(SQLstmt)
Next
response.cookies("qty") = 0
response.cookies("ord") = orn
Kaj je narobe, prosim vas za pomoč?
tnxs
Jamra okrog te kode:
orn=OrderNo()
For Each Key in dictCart
SQLstmt = "INSERT INTO orders (sid,orderno,customer,adate,code,qty,price,shipping,shipcode,description,username,card)"
SQLstmt = SQLstmt & " VALUES ("
SQLstmt = SQLstmt & "'" & sid & "',"
SQLstmt = SQLstmt & "'" & orn & "',"
SQLstmt = SQLstmt & "'" & customer & "',"
SQLstmt = SQLstmt & "'" & date() & "',"
SQLstmt = SQLstmt & "'" & key & "',"
SQLstmt = SQLstmt & "'" & dictCart(Key) & "',"
SQLstmt = SQLstmt & "'" & GetItemPrice(Key) & "',"
SQLstmt = SQLstmt & "'" & shipping & "',"
SQLstmt = SQLstmt & "'" & shipcode & "',"
SQLstmt = SQLstmt & "'" & description & "',"
SQLstmt = SQLstmt & "'" & username & "',"
SQLstmt = SQLstmt & "'" & card & "'"
SQLstmt = SQLstmt & ")"
Set RS = conn.execute(SQLstmt)
Next
response.cookies("qty") = 0
response.cookies("ord") = orn
Kaj je narobe, prosim vas za pomoč?
tnxs
OwcA ::
Morebiti si malo preveč radodaren z narekovaji. Resnično nimaš nobenih številskih tipov?
Otroška radovednost - gonilo napredka.
manger ::
OwcA: kako bi pol ti izpeljal ta sql stavek....neki so mi že pomagal na ostalih forumih, pa je blo s temi narekovaji sam se huje :)
Kaj pa mogoce to, da tabela orders nima primarnega kljuca....al zakwa ta stvar ne deluje samo v primeru, da v tabeli ni nobenga recorda
Kaj pa mogoce to, da tabela orders nima primarnega kljuca....al zakwa ta stvar ne deluje samo v primeru, da v tabeli ni nobenga recorda
OwcA ::
Za začetek povej kakšnega podatkovniega tipa je vsako polje.
Otroška radovednost - gonilo napredka.
Vredno ogleda ...
Tema | Ogledi | Zadnje sporočilo | |
---|---|---|---|
Tema | Ogledi | Zadnje sporočilo | |
» | Nakupovalni voziček, seje in update količine?Oddelek: Izdelava spletišč | 1320 (1132) | phyro |
» | Baza & c#Oddelek: Programiranje | 4153 (3211) | xardas |
» | Kje kupit Windows XP Pro in koliko stane?Oddelek: Operacijski sistemi | 4920 (3870) | bond007 |
» | ASP trgovina - asp dictionary - Key vrednost - kako ga uporabiti za pomik Move v baziOddelek: Izdelava spletišč | 951 (897) | alesrosina |
» | Http 500 internal server errorOddelek: Izdelava spletišč | 1904 (1809) | manger |