|
 |
asp_databases thread: odbc error division by zero
Message #1 by "danny njuguna" <danny@n...> on Wed, 19 Dec 2001 10:46:25
|
|
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
sql= "insert into orderitems (orderid,productid,qty,priceperunit,hooksize)
values (" & orderid & "," & acart(i,0) & "," & acart(i,1) & "," &
currentprice & "," & acart(i,2) & ")"
set rsorderitems=db.execute(sql)
when i put in a value for hooksize that is equal to 1/0 it brings the
error messege above, but when i put in a other than 1/0 it works
perfectly. How can i rewrite the spl statement so that i can incorparate
an entry of 1/0 on the hooksize field
Message #2 by "Ken Schaefer" <ken@a...> on Wed, 19 Dec 2001 21:49:30 +1100
|
|
1/0 = 1 divided by 0, which is not a number (or infinity). You can't divide
by zero.
If you want to store 1/0 as literal text, then chang the field type to a
text field.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "danny njuguna" <danny@n...>
Subject: [asp_databases] odbc error division by zero
: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
:
: [Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
:
: sql= "insert into orderitems (orderid,productid,qty,priceperunit,hooksize)
: values (" & orderid & "," & acart(i,0) & "," & acart(i,1) & "," &
: currentprice & "," & acart(i,2) & ")"
: set rsorderitems=db.execute(sql)
:
: when i put in a value for hooksize that is equal to 1/0 it brings the
: error messege above, but when i put in a other than 1/0 it works
: perfectly. How can i rewrite the spl statement so that i can incorparate
: an entry of 1/0 on the hooksize field
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by "Daniel Njuguna" <danny@n...> on Wed, 19 Dec 2001 14:28:59 +0300
|
|
the datatype on the database is text.
---------- Original Message ----------------------------------
From: "Ken Schaefer" <ken@a...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date: Wed, 19 Dec 2001 21:49:30 +1100
>1/0 = 1 divided by 0, which is not a number (or infinity). You can't divide
>by zero.
>If you want to store 1/0 as literal text, then chang the field type to a
>text field.
>
>Cheers
>Ken
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "danny njuguna" <danny@n...>
>Subject: [asp_databases] odbc error division by zero
>
>
>: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>:
>: [Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
>:
>: sql= "insert into orderitems (orderid,productid,qty,priceperunit,hooksize)
>: values (" & orderid & "," & acart(i,0) & "," & acart(i,1) & "," &
>: currentprice & "," & acart(i,2) & ")"
>: set rsorderitems=db.execute(sql)
>:
>: when i put in a value for hooksize that is equal to 1/0 it brings the
>: error messege above, but when i put in a other than 1/0 it works
>: perfectly. How can i rewrite the spl statement so that i can incorparate
>: an entry of 1/0 on the hooksize field
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
>
--
Danny Njuguna
--
Message #4 by "Kim Iwan Hansen" <kimiwan@k...> on Wed, 19 Dec 2001 12:52:23 +0100
|
|
you have to put '' around string values in your sql string.
-Kim
> -----Original Message-----
> From: Daniel Njuguna [mailto:danny@n...]
> Sent: 19. december 2001 12:29
> To: ASP Databases
> Subject: [asp_databases] Re: odbc error division by zero
>
>
> the datatype on the database is text.
>
>
> ---------- Original Message ----------------------------------
> From: "Ken Schaefer" <ken@a...>
> Reply-To: "ASP Databases" <asp_databases@p...>
> Date: Wed, 19 Dec 2001 21:49:30 +1100
>
> >1/0 = 1 divided by 0, which is not a number (or infinity). You
> can't divide
> >by zero.
> >If you want to store 1/0 as literal text, then chang the field type to a
> >text field.
> >
> >Cheers
> >Ken
> >
> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >From: "danny njuguna" <danny@n...>
> >Subject: [asp_databases] odbc error division by zero
> >
> >
> >: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> >:
> >: [Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
> >:
> >: sql= "insert into orderitems
> (orderid,productid,qty,priceperunit,hooksize)
> >: values (" & orderid & "," & acart(i,0) & "," & acart(i,1) & "," &
> >: currentprice & "," & acart(i,2) & ")"
> >: set rsorderitems=db.execute(sql)
> >:
> >: when i put in a value for hooksize that is equal to 1/0 it brings the
> >: error messege above, but when i put in a other than 1/0 it works
> >: perfectly. How can i rewrite the spl statement so that i can
> incorparate
> >: an entry of 1/0 on the hooksize field
> >
> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >
> >
> $subst('Email.Unsub').
> >
>
> --
> Danny Njuguna
> --
>
> $subst('Email.Unsub').
>
Message #5 by "Daniel Njuguna" <danny@n...> on Wed, 19 Dec 2001 15:10:53 +0300
|
|
i have tried it but it still gives me errors
---------- Original Message ----------------------------------
From: "Kim Iwan Hansen" <kimiwan@k...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date: Wed, 19 Dec 2001 12:52:23 +0100
>you have to put '' around string values in your sql string.
>
>-Kim
>
>
>> -----Original Message-----
>> From: Daniel Njuguna [mailto:danny@n...]
>> Sent: 19. december 2001 12:29
>> To: ASP Databases
>> Subject: [asp_databases] Re: odbc error division by zero
>>
>>
>> the datatype on the database is text.
>>
>>
>> ---------- Original Message ----------------------------------
>> From: "Ken Schaefer" <ken@a...>
>> Reply-To: "ASP Databases" <asp_databases@p...>
>> Date: Wed, 19 Dec 2001 21:49:30 +1100
>>
>> >1/0 = 1 divided by 0, which is not a number (or infinity). You
>> can't divide
>> >by zero.
>> >If you want to store 1/0 as literal text, then chang the field type to a
>> >text field.
>> >
>> >Cheers
>> >Ken
>> >
>> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> >From: "danny njuguna" <danny@n...>
>> >Subject: [asp_databases] odbc error division by zero
>> >
>> >
>> >: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>> >:
>> >: [Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
>> >:
>> >: sql= "insert into orderitems
>> (orderid,productid,qty,priceperunit,hooksize)
>> >: values (" & orderid & "," & acart(i,0) & "," & acart(i,1) & "," &
>> >: currentprice & "," & acart(i,2) & ")"
>> >: set rsorderitems=db.execute(sql)
>> >:
>> >: when i put in a value for hooksize that is equal to 1/0 it brings the
>> >: error messege above, but when i put in a other than 1/0 it works
>> >: perfectly. How can i rewrite the spl statement so that i can
>> incorparate
>> >: an entry of 1/0 on the hooksize field
>> >
>> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> >
>> >
>> $subst('Email.Unsub').
>> >
>>
>> --
>> Danny Njuguna
>> --
>>
>> $subst('Email.Unsub').
>>
>
>
--
Danny Njuguna
--
Message #6 by "Kim Iwan Hansen" <kimiwan@k...> on Wed, 19 Dec 2001 13:25:00 +0100
|
|
is it the same error (i.e. division by zero)?
what do you have in the acart() function, and what value are you passing to
it (i)
-Kim
> -----Original Message-----
> From: Daniel Njuguna [mailto:danny@n...]
> Sent: 19. december 2001 13:11
> To: ASP Databases
> Subject: [asp_databases] Re: odbc error division by zero
>
>
> i have tried it but it still gives me errors
>
>
> ---------- Original Message ----------------------------------
> From: "Kim Iwan Hansen" <kimiwan@k...>
> Reply-To: "ASP Databases" <asp_databases@p...>
> Date: Wed, 19 Dec 2001 12:52:23 +0100
>
> >you have to put '' around string values in your sql string.
> >
> >-Kim
> >
> >
> >> -----Original Message-----
> >> From: Daniel Njuguna [mailto:danny@n...]
> >> Sent: 19. december 2001 12:29
> >> To: ASP Databases
> >> Subject: [asp_databases] Re: odbc error division by zero
> >>
> >>
> >> the datatype on the database is text.
> >>
> >>
> >> ---------- Original Message ----------------------------------
> >> From: "Ken Schaefer" <ken@a...>
> >> Reply-To: "ASP Databases" <asp_databases@p...>
> >> Date: Wed, 19 Dec 2001 21:49:30 +1100
> >>
> >> >1/0 = 1 divided by 0, which is not a number (or infinity). You
> >> can't divide
> >> >by zero.
> >> >If you want to store 1/0 as literal text, then chang the
> field type to a
> >> >text field.
> >> >
> >> >Cheers
> >> >Ken
> >> >
> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >> >From: "danny njuguna" <danny@n...>
> >> >Subject: [asp_databases] odbc error division by zero
> >> >
> >> >
> >> >: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> >> >:
> >> >: [Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
> >> >:
> >> >: sql= "insert into orderitems
> >> (orderid,productid,qty,priceperunit,hooksize)
> >> >: values (" & orderid & "," & acart(i,0) & "," & acart(i,1) & "," &
> >> >: currentprice & "," & acart(i,2) & ")"
> >> >: set rsorderitems=db.execute(sql)
> >> >:
> >> >: when i put in a value for hooksize that is equal to 1/0 it
> brings the
> >> >: error messege above, but when i put in a other than 1/0 it works
> >> >: perfectly. How can i rewrite the spl statement so that i can
> >> incorparate
> >> >: an entry of 1/0 on the hooksize field
> >> >
> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >> >
> >> >
> >> $subst('Email.Unsub').
> >> >
> >>
> >> --
> >> Danny Njuguna
> >> --
> >>
> >> $subst('Email.Unsub').
> >>
> >
> $subst('Email.Unsub').
> >
>
> --
> Danny Njuguna
> --
>
> $subst('Email.Unsub').
>
Message #7 by "Daniel Njuguna" <danny@n...> on Wed, 19 Dec 2001 15:31:56 +0300
|
|
this is the script in the entry page where i put in the details
If IsArray(Session("cart")) = false Then
Dim acart(299,2)
acart(1,0)=productid
acart(0,1)=request.form("qty")
acart(0,2)=request.form("hooksize")
else
acart=session("cart")
incart=false
for i=lbound(acart) to ubound(acart)
if acart(i,0)="" and acart(i,1)="" and acart(i,2)="" and not(incart) then
acart(i,0)=productid
acart(i,1)=request.form("qty")
acart(i,2)=request.form("hooksize")
incart=true
end if
next
session("cart")=acart
end if
end if
and the following script is the page where i update the database (this is where i get the error
If IsArray(Session("cart")) = false Then
Dim acart(299,2)
Session("cart") = acart
response.redirect("error.asp?msg=" & Server.URLEncode("Your shopping cart is empty."))
end if
acart=Session("cart")
cempty=true
for i=lbound(acart) to ubound(acart)
if acart(i,0)<>"" and acart(i,1)<>"" and acart(i,2)<>"" then
cempty=false
end if
next
if cempty then
response.redirect("review.asp")
end if
---------- Original Message ----------------------------------
From: "Kim Iwan Hansen" <kimiwan@k...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date: Wed, 19 Dec 2001 13:25:00 +0100
>is it the same error (i.e. division by zero)?
>
>what do you have in the acart() function, and what value are you passing to
>it (i)
>
>-Kim
>
>> -----Original Message-----
>> From: Daniel Njuguna [mailto:danny@n...]
>> Sent: 19. december 2001 13:11
>> To: ASP Databases
>> Subject: [asp_databases] Re: odbc error division by zero
>>
>>
>> i have tried it but it still gives me errors
>>
>>
>> ---------- Original Message ----------------------------------
>> From: "Kim Iwan Hansen" <kimiwan@k...>
>> Reply-To: "ASP Databases" <asp_databases@p...>
>> Date: Wed, 19 Dec 2001 12:52:23 +0100
>>
>> >you have to put '' around string values in your sql string.
>> >
>> >-Kim
>> >
>> >
>> >> -----Original Message-----
>> >> From: Daniel Njuguna [mailto:danny@n...]
>> >> Sent: 19. december 2001 12:29
>> >> To: ASP Databases
>> >> Subject: [asp_databases] Re: odbc error division by zero
>> >>
>> >>
>> >> the datatype on the database is text.
>> >>
>> >>
>> >> ---------- Original Message ----------------------------------
>> >> From: "Ken Schaefer" <ken@a...>
>> >> Reply-To: "ASP Databases" <asp_databases@p...>
>> >> Date: Wed, 19 Dec 2001 21:49:30 +1100
>> >>
>> >> >1/0 = 1 divided by 0, which is not a number (or infinity). You
>> >> can't divide
>> >> >by zero.
>> >> >If you want to store 1/0 as literal text, then chang the
>> field type to a
>> >> >text field.
>> >> >
>> >> >Cheers
>> >> >Ken
>> >> >
>> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> >> >From: "danny njuguna" <danny@n...>
>> >> >Subject: [asp_databases] odbc error division by zero
>> >> >
>> >> >
>> >> >: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>> >> >:
>> >> >: [Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
>> >> >:
>> >> >: sql= "insert into orderitems
>> >> (orderid,productid,qty,priceperunit,hooksize)
>> >> >: values (" & orderid & "," & acart(i,0) & "," & acart(i,1) & "," &
>> >> >: currentprice & "," & acart(i,2) & ")"
>> >> >: set rsorderitems=db.execute(sql)
>> >> >:
>> >> >: when i put in a value for hooksize that is equal to 1/0 it
>> brings the
>> >> >: error messege above, but when i put in a other than 1/0 it works
>> >> >: perfectly. How can i rewrite the spl statement so that i can
>> >> incorparate
>> >> >: an entry of 1/0 on the hooksize field
>> >> >
>> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> >> >
>> >> >
>> >> $subst('Email.Unsub').
>> >> >
>> >>
>> >> --
>> >> Danny Njuguna
>> >> --
>> >>
>> >> $subst('Email.Unsub').
>> >>
>> >
>> $subst('Email.Unsub').
>> >
>>
>> --
>> Danny Njuguna
>> --
>>
>> $subst('Email.Unsub').
>>
>
>
>
--
Danny Njuguna
--
Message #8 by "Kim Iwan Hansen" <kimiwan@k...> on Wed, 19 Dec 2001 14:21:09 +0100
|
|
do you mind double-checking that hooksize is really a text type field in
your database?
do you get any errors if you try to insert for example 1/1? what if you try
to insert "blahblahblah" into hooksize?
-Kim
> -----Original Message-----
> From: Daniel Njuguna [mailto:danny@n...]
> Sent: 19. december 2001 13:32
> To: ASP Databases
> Subject: [asp_databases] Re: odbc error division by zero
>
>
> this is the script in the entry page where i put in the details
>
>
> If IsArray(Session("cart")) = false Then
> Dim acart(299,2)
> acart(1,0)=productid
> acart(0,1)=request.form("qty")
> acart(0,2)=request.form("hooksize")
> else
> acart=session("cart")
> incart=false
> for i=lbound(acart) to ubound(acart)
> if acart(i,0)="" and acart(i,1)="" and
> acart(i,2)="" and not(incart) then
> acart(i,0)=productid
> acart(i,1)=request.form("qty")
> acart(i,2)=request.form("hooksize")
> incart=true
> end if
> next
>
> session("cart")=acart
> end if
> end if
>
>
>
>
> and the following script is the page where i update the database
> (this is where i get the error
>
> If IsArray(Session("cart")) = false Then
> Dim acart(299,2)
> Session("cart") = acart
> response.redirect("error.asp?msg=" &
> Server.URLEncode("Your shopping cart is empty."))
> end if
> acart=Session("cart")
> cempty=true
> for i=lbound(acart) to ubound(acart)
> if acart(i,0)<>"" and acart(i,1)<>"" and acart(i,2)<>"" then
> cempty=false
> end if
> next
> if cempty then
> response.redirect("review.asp")
> end if
>
>
>
> ---------- Original Message ----------------------------------
> From: "Kim Iwan Hansen" <kimiwan@k...>
> Reply-To: "ASP Databases" <asp_databases@p...>
> Date: Wed, 19 Dec 2001 13:25:00 +0100
>
> >is it the same error (i.e. division by zero)?
> >
> >what do you have in the acart() function, and what value are you
> passing to
> >it (i)
> >
> >-Kim
> >
> >> -----Original Message-----
> >> From: Daniel Njuguna [mailto:danny@n...]
> >> Sent: 19. december 2001 13:11
> >> To: ASP Databases
> >> Subject: [asp_databases] Re: odbc error division by zero
> >>
> >>
> >> i have tried it but it still gives me errors
> >>
> >>
> >> ---------- Original Message ----------------------------------
> >> From: "Kim Iwan Hansen" <kimiwan@k...>
> >> Reply-To: "ASP Databases" <asp_databases@p...>
> >> Date: Wed, 19 Dec 2001 12:52:23 +0100
> >>
> >> >you have to put '' around string values in your sql string.
> >> >
> >> >-Kim
> >> >
> >> >
> >> >> -----Original Message-----
> >> >> From: Daniel Njuguna [mailto:danny@n...]
> >> >> Sent: 19. december 2001 12:29
> >> >> To: ASP Databases
> >> >> Subject: [asp_databases] Re: odbc error division by zero
> >> >>
> >> >>
> >> >> the datatype on the database is text.
> >> >>
> >> >>
> >> >> ---------- Original Message ----------------------------------
> >> >> From: "Ken Schaefer" <ken@a...>
> >> >> Reply-To: "ASP Databases" <asp_databases@p...>
> >> >> Date: Wed, 19 Dec 2001 21:49:30 +1100
> >> >>
> >> >> >1/0 = 1 divided by 0, which is not a number (or infinity). You
> >> >> can't divide
> >> >> >by zero.
> >> >> >If you want to store 1/0 as literal text, then chang the
> >> field type to a
> >> >> >text field.
> >> >> >
> >> >> >Cheers
> >> >> >Ken
> >> >> >
> >> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >> >> >From: "danny njuguna" <danny@n...>
> >> >> >Subject: [asp_databases] odbc error division by zero
> >> >> >
> >> >> >
> >> >> >: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> >> >> >:
> >> >> >: [Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
> >> >> >:
> >> >> >: sql= "insert into orderitems
> >> >> (orderid,productid,qty,priceperunit,hooksize)
> >> >> >: values (" & orderid & "," & acart(i,0) & "," & acart(i,1) & "," &
> >> >> >: currentprice & "," & acart(i,2) & ")"
> >> >> >: set rsorderitems=db.execute(sql)
> >> >> >:
> >> >> >: when i put in a value for hooksize that is equal to 1/0 it
> >> brings the
> >> >> >: error messege above, but when i put in a other than 1/0 it works
> >> >> >: perfectly. How can i rewrite the spl statement so that i can
> >> >> incorparate
> >> >> >: an entry of 1/0 on the hooksize field
> >> >> >
> >> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >> >> >
> >> >> >
> >> >> $subst('Email.Unsub').
> >> >> >
> >> >>
> >> >> --
> >> >> Danny Njuguna
> >> >> --
> >> >>
> >> >> $subst('Email.Unsub').
> >> >>
> >> >
> >> $subst('Email.Unsub').
> >> >
> >>
> >> --
> >> Danny Njuguna
> >> --
> >>
> >> $subst('Email.Unsub').
> >>
> >
> >
> $subst('Email.Unsub').
> >
>
> --
> Danny Njuguna
> --
>
> $subst('Email.Unsub').
>
Message #9 by "danny njuguna" <danny@n...> on Thu, 20 Dec 2001 05:23:09
|
|
> do you mind double-checking that hooksize is really a text type field in
> your database?
>
> do you get any errors if you try to insert for example 1/1? what if you
try
> to insert "blahblahblah" into hooksize?
>
> -Kim
>
>
>
> > -----Original Message-----
> > From: Daniel Njuguna [mailto:danny@n...]
> > Sent: 19. december 2001 13:32
> > To: ASP Databases
> > Subject: [asp_databases] Re: odbc error division by zero
> >
> >
> > this is the script in the entry page where i put in the details
> >
> >
> > If IsArray(Session("cart")) = false Then
> > Dim acart(299,2)
> > acart(1,0)=productid
> > acart(0,1)=request.form("qty")
> > acart(0,2)=request.form("hooksize")
> > else
> > acart=session("cart")
> > incart=false
> > for i=lbound(acart) to ubound(acart)
> > if acart(i,0)="" and acart(i,1)="" and
> > acart(i,2)="" and not(incart) then
> > acart(i,0)=productid
> > acart(i,1)=request.form("qty")
> > acart(i,2)=request.form("hooksize")
> > incart=true
> > end if
> > next
> >
> > session("cart")=acart
> > end if
> > end if
> >
> >
> >
> >
> > and the following script is the page where i update the database
> > (this is where i get the error
> >
> > If IsArray(Session("cart")) = false Then
> > Dim acart(299,2)
> > Session("cart") = acart
> > response.redirect("error.asp?msg=" &
> > Server.URLEncode("Your shopping cart is empty."))
> > end if
> > acart=Session("cart")
> > cempty=true
> > for i=lbound(acart) to ubound(acart)
> > if acart(i,0)<>"" and acart(i,1)<>"" and acart(i,2)<>"" then
> > cempty=false
> > end if
> > next
> > if cempty then
> > response.redirect("review.asp")
> > end if
> >
> >
> >
> > ---------- Original Message ----------------------------------
> > From: "Kim Iwan Hansen" <kimiwan@k...>
> > Reply-To: "ASP Databases" <asp_databases@p...>
> > Date: Wed, 19 Dec 2001 13:25:00 +0100
> >
> > >is it the same error (i.e. division by zero)?
> > >
> > >what do you have in the acart() function, and what value are you
> > passing to
> > >it (i)
> > >
> > >-Kim
> > >
> > >> -----Original Message-----
> > >> From: Daniel Njuguna [mailto:danny@n...]
> > >> Sent: 19. december 2001 13:11
> > >> To: ASP Databases
> > >> Subject: [asp_databases] Re: odbc error division by zero
> > >>
> > >>
> > >> i have tried it but it still gives me errors
> > >>
> > >>
> > >> ---------- Original Message ----------------------------------
> > >> From: "Kim Iwan Hansen" <kimiwan@k...>
> > >> Reply-To: "ASP Databases" <asp_databases@p...>
> > >> Date: Wed, 19 Dec 2001 12:52:23 +0100
> > >>
> > >> >you have to put '' around string values in your sql string.
> > >> >
> > >> >-Kim
> > >> >
> > >> >
> > >> >> -----Original Message-----
> > >> >> From: Daniel Njuguna [mailto:danny@n...]
> > >> >> Sent: 19. december 2001 12:29
> > >> >> To: ASP Databases
> > >> >> Subject: [asp_databases] Re: odbc error division by zero
> > >> >>
> > >> >>
> > >> >> the datatype on the database is text.
> > >> >>
> > >> >>
> > >> >> ---------- Original Message ----------------------------------
> > >> >> From: "Ken Schaefer" <ken@a...>
> > >> >> Reply-To: "ASP Databases" <asp_databases@p...>
> > >> >> Date: Wed, 19 Dec 2001 21:49:30 +1100
> > >> >>
> > >> >> >1/0 = 1 divided by 0, which is not a number (or infinity). You
> > >> >> can't divide
> > >> >> >by zero.
> > >> >> >If you want to store 1/0 as literal text, then chang the
> > >> field type to a
> > >> >> >text field.
> > >> >> >
> > >> >> >Cheers
> > >> >> >Ken
> > >> >> >
> > >> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > >> >> >From: "danny njuguna" <danny@n...>
> > >> >> >Subject: [asp_databases] odbc error division by zero
> > >> >> >
> > >> >> >
> > >> >> >: Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> > >> >> >:
> > >> >> >: [Microsoft][ODBC Microsoft Access Driver]Division by zero
(null)
> > >> >> >:
> > >> >> >: sql= "insert into orderitems
> > >> >> (orderid,productid,qty,priceperunit,hooksize)
> > >> >> >: values (" & orderid & "," & acart(i,0) & "," & acart(i,1)
& "," &
> > >> >> >: currentprice & "," & acart(i,2) & ")"
> > >> >> >: set rsorderitems=db.execute(sql)
> > >> >> >:
> > >> >> >: when i put in a value for hooksize that is equal to 1/0 it
> > >> brings the
> > >> >> >: error messege above, but when i put in a other than 1/0 it
works
> > >> >> >: perfectly. How can i rewrite the spl statement so that i can
> > >> >> incorparate
> > >> >> >: an entry of 1/0 on the hooksize field
> > >> >> >
> > >> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > >> >> >
> > >> >> >
> > >> >> $subst('Email.Unsub').
> > >> >> >
> > >> >>
> > >> >> --
> > >> >> Danny Njuguna
> > >> >> --
> > >> >>
> > >> >> $subst('Email.Unsub').
> > >> >>
> > >> >
> > >> $subst('Email.Unsub').
> > >> >
> > >>
> > >> --
> > >> Danny Njuguna
> > >> --
> > >>
> > >> $subst('Email.Unsub').
> > >>
> > >
> > >
> > $subst('Email.Unsub').
> > >
> >
> > --
> > Danny Njuguna
> > --
> >
> > $subst('Email.Unsub').
> >
>
Message #10 by "danny njuguna" <danny@n...> on Thu, 20 Dec 2001 05:25:31
|
|
i have double checked, i have noticed that when i put the division sign
like 1/2 or 1/1 or 1/3 it does the mathmatical calculation, this is very
wired. I have gone to the database itself and manually put 1/2 or 1/0 and
it accepts it. what am i missing , please help thanks
Message #11 by "Ken Schaefer" <ken@a...> on Thu, 20 Dec 2001 23:22:05 +1100
|
|
IIRC In your original SQL statement that you posted, you did not put ' marks
around the text value. So the database thinks that you want to evaluate a
numeric expression and store the result in the table. You need to put '
around the value you want to store.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "danny njuguna" <danny@n...>
Subject: [asp_databases] Re: odbc error division by zero
: i have double checked, i have noticed that when i put the division sign
: like 1/2 or 1/1 or 1/3 it does the mathmatical calculation, this is very
: wired. I have gone to the database itself and manually put 1/2 or 1/0 and
: it accepts it. what am i missing , please help thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #12 by "danny njuguna" <danny@n...> on Thu, 20 Dec 2001 14:37:37
|
|
[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement
contains the following unknown field name: ''hooksize''. Make sure you
have typed the name correctly, and try the operation again.
This is the Error it gives me now.
danny
> IIRC In your original SQL statement that you posted, you did not put '
marks
> around the text value. So the database thinks that you want to evaluate a
> numeric expression and store the result in the table. You need to put '
> around the value you want to store.
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: "danny njuguna" <danny@n...>
> Subject: [asp_databases] Re: odbc error division by zero
>
>
> : i have double checked, i have noticed that when i put the division sign
> : like 1/2 or 1/1 or 1/3 it does the mathmatical calculation, this is
very
> : wired. I have gone to the database itself and manually put 1/2 or 1/0
and
> : it accepts it. what am i missing , please help thanks
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
Message #13 by "Ken Schaefer" <ken@a...> on Fri, 21 Dec 2001 12:30:53 +1100
|
|
So what is your SQL Statement now? Do you have a field called "hooksize" in
the table in question?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "danny njuguna" <danny@n...>
Subject: [asp_databases] Re: odbc error division by zero
: [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement
: contains the following unknown field name: ''hooksize''. Make sure you
: have typed the name correctly, and try the operation again.
:
: This is the Error it gives me now.
:
: danny
:
:
: > IIRC In your original SQL statement that you posted, you did not put '
: marks
: > around the text value. So the database thinks that you want to evaluate
a
: > numeric expression and store the result in the table. You need to put '
: > around the value you want to store.
: >
: > Cheers
: > Ken
Message #14 by "Daniel Njuguna" <danny@n...> on Fri, 21 Dec 2001 17:37:30 +0300
|
|
I still have my field name as hooksize in the database , the SQL statement is as follows
sql= "insert into orderitems (orderid,productid,qty,priceperunit,'hooksize') values (" & orderid & "," & acart(i,0)
& "," & acart(i,1) & "," & currentprice & "," & acart(i,2) & ")"
set rsorderitems=db.execute(sql)
---------- Original Message ----------------------------------
From: "Ken Schaefer" <ken@a...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date: Fri, 21 Dec 2001 12:30:53 +1100
>So what is your SQL Statement now? Do you have a field called "hooksize" in
>the table in question?
>
>Cheers
>Ken
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "danny njuguna" <danny@n...>
>Subject: [asp_databases] Re: odbc error division by zero
>
>
>: [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement
>: contains the following unknown field name: ''hooksize''. Make sure you
>: have typed the name correctly, and try the operation again.
>:
>: This is the Error it gives me now.
>:
>: danny
>:
>:
>: > IIRC In your original SQL statement that you posted, you did not put '
>: marks
>: > around the text value. So the database thinks that you want to evaluate
>a
>: > numeric expression and store the result in the table. You need to put '
>: > around the value you want to store.
>: >
>: > Cheers
>: > Ken
>
>
>
>
--
Danny Njuguna
--
Message #15 by "Tomm Matthis" <matthis@b...> on Fri, 21 Dec 2001 09:52:20 -0500
|
|
Why is the fieldname hooksize in single quotes inside the string?
-- Tomm
> -----Original Message-----
> From: Daniel Njuguna [mailto:danny@n...]
> Sent: Friday, December 21, 2001 9:38 AM
> To: ASP Databases
> Subject: [asp_databases] Re: odbc error division by zero
>
>
> I still have my field name as hooksize in the database , the SQL
> statement is as follows
>
> sql= "insert into orderitems
> (orderid,productid,qty,priceperunit,'hooksize') values (" & orderid
> & "," & acart(i,0) & "," & acart(i,1) & "," & currentprice & "," &
> acart(i,2) & ")"
> set rsorderitems=db.execute(sql)
>
>
>
> ---------- Original Message ----------------------------------
> From: "Ken Schaefer" <ken@a...>
> Reply-To: "ASP Databases" <asp_databases@p...>
> Date: Fri, 21 Dec 2001 12:30:53 +1100
>
> >So what is your SQL Statement now? Do you have a field called "hooksize" in
> >the table in question?
> >
> >Cheers
> >Ken
> >
> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >From: "danny njuguna" <danny@n...>
> >Subject: [asp_databases] Re: odbc error division by zero
> >
> >
> >: [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement
> >: contains the following unknown field name: ''hooksize''. Make sure you
> >: have typed the name correctly, and try the operation again.
> >:
> >: This is the Error it gives me now.
> >:
> >: danny
> >:
> >:
> >: > IIRC In your original SQL statement that you posted, you did not put '
> >: marks
> >: > around the text value. So the database thinks that you want to evaluate
> >a
> >: > numeric expression and store the result in the table. You need to put '
> >: > around the value you want to store.
> >: >
> >: > Cheers
> >: > Ken
> >
> >
> >
> $subst('Email.Unsub').
> >
>
> --
> Danny Njuguna
> --
>
> $subst('Email.Unsub').
Message #16 by "Daniel Njuguna" <danny@n...> on Sat, 22 Dec 2001 14:55:44 +0300
|
|
Hi
how am i supposed to write it so that i can input a text field into the database without doing a mathematical calculation.
---------- Original Message ----------------------------------
From: "Tomm Matthis" <matthis@b...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date: Fri, 21 Dec 2001 09:52:20 -0500
>Why is the fieldname hooksize in single quotes inside the string?
>
>-- Tomm
>
>> -----Original Message-----
>> From: Daniel Njuguna [mailto:danny@n...]
>> Sent: Friday, December 21, 2001 9:38 AM
>> To: ASP Databases
>> Subject: [asp_databases] Re: odbc error division by zero
>>
>>
>> I still have my field name as hooksize in the database , the SQL
>> statement is as follows
>>
>> sql= "insert into orderitems
>> (orderid,productid,qty,priceperunit,'hooksize') values (" & orderid
>> & "," & acart(i,0) & "," & acart(i,1) & "," & currentprice & "," &
>> acart(i,2) & ")"
>> set rsorderitems=db.execute(sql)
>>
>>
>>
>> ---------- Original Message ----------------------------------
>> From: "Ken Schaefer" <ken@a...>
>> Reply-To: "ASP Databases" <asp_databases@p...>
>> Date: Fri, 21 Dec 2001 12:30:53 +1100
>>
>> >So what is your SQL Statement now? Do you have a field called "hooksize" in
>> >the table in question?
>> >
>> >Cheers
>> >Ken
>> >
>> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> >From: "danny njuguna" <danny@n...>
>> >Subject: [asp_databases] Re: odbc error division by zero
>> >
>> >
>> >: [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement
>> >: contains the following unknown field name: ''hooksize''. Make sure you
>> >: have typed the name correctly, and try the operation again.
>> >:
>> >: This is the Error it gives me now.
>> >:
>> >: danny
>> >:
>> >:
>> >: > IIRC In your original SQL statement that you posted, you did not put '
>> >: marks
>> >: > around the text value. So the database thinks that you want to evaluate
>> >a
>> >: > numeric expression and store the result in the table. You need to put '
>> >: > around the value you want to store.
>> >: >
>> >: > Cheers
>> >: > Ken
>> >
>> >
>> >
>> $subst('Email.Unsub').
>> >
>>
>> --
>> Danny Njuguna
>> --
>>
>> $subst('Email.Unsub').
>
>
>
--
Danny Njuguna
--
Message #17 by "Kim Iwan Hansen" <kimiwan@k...> on Sat, 22 Dec 2001 14:02:21 +0100
|
|
...,hooksize)... ...,'" & acart(i,2) & "')"
you want to put '' around the value you're inserting - not around the field
name.
-Kim
> -----Original Message-----
> From: Daniel Njuguna [mailto:danny@n...]
> Sent: 22. december 2001 12:56
> To: ASP Databases
> Subject: [asp_databases] Re: odbc error division by zero
>
>
> Hi
> how am i supposed to write it so that i can input a text field
> into the database without doing a mathematical calculation.
>
>
> ---------- Original Message ----------------------------------
> From: "Tomm Matthis" <matthis@b...>
> Reply-To: "ASP Databases" <asp_databases@p...>
> Date: Fri, 21 Dec 2001 09:52:20 -0500
>
> >Why is the fieldname hooksize in single quotes inside the string?
> >
> >-- Tomm
> >
> >> -----Original Message-----
> >> From: Daniel Njuguna [mailto:danny@n...]
> >> Sent: Friday, December 21, 2001 9:38 AM
> >> To: ASP Databases
> >> Subject: [asp_databases] Re: odbc error division by zero
> >>
> >>
> >> I still have my field name as hooksize in the database , the SQL
> >> statement is as follows
> >>
> >> sql= "insert into orderitems
> >> (orderid,productid,qty,priceperunit,'hooksize') values (" & orderid
> >> & "," & acart(i,0) & "," & acart(i,1) & "," & currentprice & "," &
> >> acart(i,2) & ")"
> >> set rsorderitems=db.execute(sql)
> >>
> >>
> >>
> >> ---------- Original Message ----------------------------------
> >> From: "Ken Schaefer" <ken@a...>
> >> Reply-To: "ASP Databases" <asp_databases@p...>
> >> Date: Fri, 21 Dec 2001 12:30:53 +1100
> >>
> >> >So what is your SQL Statement now? Do you have a field called
> "hooksize" in
> >> >the table in question?
> >> >
> >> >Cheers
> >> >Ken
> >> >
> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >> >From: "danny njuguna" <danny@n...>
> >> >Subject: [asp_databases] Re: odbc error division by zero
> >> >
> >> >
> >> >: [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement
> >> >: contains the following unknown field name: ''hooksize''.
> Make sure you
> >> >: have typed the name correctly, and try the operation again.
> >> >:
> >> >: This is the Error it gives me now.
> >> >:
> >> >: danny
> >> >:
> >> >:
> >> >: > IIRC In your original SQL statement that you posted, you
> did not put '
> >> >: marks
> >> >: > around the text value. So the database thinks that you
> want to evaluate
> >> >a
> >> >: > numeric expression and store the result in the table. You
> need to put '
> >> >: > around the value you want to store.
> >> >: >
> >> >: > Cheers
> >> >: > Ken
> >> >
> >> >
> >> >
> >> $subst('Email.Unsub').
> >> >
> >>
> >> --
> >> Danny Njuguna
> >> --
> >>
> >> $subst('Email.Unsub').
> >
> >
> $subst('Email.Unsub').
> >
>
> --
> Danny Njuguna
> --
>
> $subst('Email.Unsub').
>
Message #18 by "Daniel Njuguna" <danny@n...> on Sat, 22 Dec 2001 16:18:17 +0300
|
|
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query expression '1/0')'.
this is the error i get now.
---------- Original Message ----------------------------------
From: "Kim Iwan Hansen" <kimiwan@k...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date: Sat, 22 Dec 2001 14:02:21 +0100
>...,hooksize)... ...,'" & acart(i,2) & "')"
>
>you want to put '' around the value you're inserting - not around the field
>name.
>
>-Kim
>
>
>> -----Original Message-----
>> From: Daniel Njuguna [mailto:danny@n...]
>> Sent: 22. december 2001 12:56
>> To: ASP Databases
>> Subject: [asp_databases] Re: odbc error division by zero
>>
>>
>> Hi
>> how am i supposed to write it so that i can input a text field
>> into the database without doing a mathematical calculation.
>>
>>
>> ---------- Original Message ----------------------------------
>> From: "Tomm Matthis" <matthis@b...>
>> Reply-To: "ASP Databases" <asp_databases@p...>
>> Date: Fri, 21 Dec 2001 09:52:20 -0500
>>
>> >Why is the fieldname hooksize in single quotes inside the string?
>> >
>> >-- Tomm
>> >
>> >> -----Original Message-----
>> >> From: Daniel Njuguna [mailto:danny@n...]
>> >> Sent: Friday, December 21, 2001 9:38 AM
>> >> To: ASP Databases
>> >> Subject: [asp_databases] Re: odbc error division by zero
>> >>
>> >>
>> >> I still have my field name as hooksize in the database , the SQL
>> >> statement is as follows
>> >>
>> >> sql= "insert into orderitems
>> >> (orderid,productid,qty,priceperunit,'hooksize') values (" & orderid
>> >> & "," & acart(i,0) & "," & acart(i,1) & "," & currentprice & "," &
>> >> acart(i,2) & ")"
>> >> set rsorderitems=db.execute(sql)
>> >>
>> >>
>> >>
>> >> ---------- Original Message ----------------------------------
>> >> From: "Ken Schaefer" <ken@a...>
>> >> Reply-To: "ASP Databases" <asp_databases@p...>
>> >> Date: Fri, 21 Dec 2001 12:30:53 +1100
>> >>
>> >> >So what is your SQL Statement now? Do you have a field called
>> "hooksize" in
>> >> >the table in question?
>> >> >
>> >> >Cheers
>> >> >Ken
>> >> >
>> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> >> >From: "danny njuguna" <danny@n...>
>> >> >Subject: [asp_databases] Re: odbc error division by zero
>> >> >
>> >> >
>> >> >: [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement
>> >> >: contains the following unknown field name: ''hooksize''.
>> Make sure you
>> >> >: have typed the name correctly, and try the operation again.
>> >> >:
>> >> >: This is the Error it gives me now.
>> >> >:
>> >> >: danny
>> >> >:
>> >> >:
>> >> >: > IIRC In your original SQL statement that you posted, you
>> did not put '
>> >> >: marks
>> >> >: > around the text value. So the database thinks that you
>> want to evaluate
>> >> >a
>> >> >: > numeric expression and store the result in the table. You
>> need to put '
>> >> >: > around the value you want to store.
>> >> >: >
>> >> >: > Cheers
>> >> >: > Ken
>> >> >
>> >> >
>> >> >
>> >> $subst('Email.Unsub').
>> >> >
>> >>
>> >> --
>> >> Danny Njuguna
>> >> --
>> >>
>> >> $subst('Email.Unsub').
>> >
>> >
>> $subst('Email.Unsub').
>> >
>>
>> --
>> Danny Njuguna
>> --
>>
>> $subst('Email.Unsub').
>>
>
>
>
--
Danny Njuguna
--
Message #19 by "Kim Iwan Hansen" <kimiwan@k...> on Sat, 22 Dec 2001 14:29:47 +0100
|
|
> -----Original Message-----
> From: Daniel Njuguna [mailto:danny@n...]
> Sent: 22. december 2001 14:18
> To: ASP Databases
> Subject: [asp_databases] Re: odbc error division by zero
>
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in string
> in query expression '1/0')'.
>
> this is the error i get now.
>
>
> ---------- Original Message ----------------------------------
> From: "Kim Iwan Hansen" <kimiwan@k...>
> Reply-To: "ASP Databases" <asp_databases@p...>
> Date: Sat, 22 Dec 2001 14:02:21 +0100
>
> >...,hooksize)... ...,'" & acart(i,2) & "')"
> >
> >you want to put '' around the value you're inserting - not
> around the field
> >name.
> >
> >-Kim
> >
> >
> >> -----Original Message-----
> >> From: Daniel Njuguna [mailto:danny@n...]
> >> Sent: 22. december 2001 12:56
> >> To: ASP Databases
> >> Subject: [asp_databases] Re: odbc error division by zero
> >>
> >>
> >> Hi
> >> how am i supposed to write it so that i can input a text field
> >> into the database without doing a mathematical calculation.
> >>
> >>
> >> ---------- Original Message ----------------------------------
> >> From: "Tomm Matthis" <matthis@b...>
> >> Reply-To: "ASP Databases" <asp_databases@p...>
> >> Date: Fri, 21 Dec 2001 09:52:20 -0500
> >>
> >> >Why is the fieldname hooksize in single quotes inside the string?
> >> >
> >> >-- Tomm
> >> >
> >> >> -----Original Message-----
> >> >> From: Daniel Njuguna [mailto:danny@n...]
> >> >> Sent: Friday, December 21, 2001 9:38 AM
> >> >> To: ASP Databases
> >> >> Subject: [asp_databases] Re: odbc error division by zero
> >> >>
> >> >>
> >> >> I still have my field name as hooksize in the database , the SQL
> >> >> statement is as follows
> >> >>
> >> >> sql= "insert into orderitems
> >> >> (orderid,productid,qty,priceperunit,'hooksize') values (" & orderid
> >> >> & "," & acart(i,0) & "," & acart(i,1) & "," & currentprice & "," &
> >> >> acart(i,2) & ")"
> >> >> set rsorderitems=db.execute(sql)
> >> >>
> >> >>
> >> >>
> >> >> ---------- Original Message ----------------------------------
> >> >> From: "Ken Schaefer" <ken@a...>
> >> >> Reply-To: "ASP Databases" <asp_databases@p...>
> >> >> Date: Fri, 21 Dec 2001 12:30:53 +1100
> >> >>
> >> >> >So what is your SQL Statement now? Do you have a field called
> >> "hooksize" in
> >> >> >the table in question?
> >> >> >
> >> >> >Cheers
> >> >> >Ken
> >> >> >
> >> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >> >> >From: "danny njuguna" <danny@n...>
> >> >> >Subject: [asp_databases] Re: odbc error division by zero
> >> >> >
> >> >> >
> >> >> >: [Microsoft][ODBC Microsoft Access Driver] The INSERT
> INTO statement
> >> >> >: contains the following unknown field name: ''hooksize''.
> >> Make sure you
> >> >> >: have typed the name correctly, and try the operation again.
> >> >> >:
> >> >> >: This is the Error it gives me now.
> >> >> >:
> >> >> >: danny
> >> >> >:
> >> >> >:
> >> >> >: > IIRC In your original SQL statement that you posted, you
> >> did not put '
> >> >> >: marks
> >> >> >: > around the text value. So the database thinks that you
> >> want to evaluate
> >> >> >a
> >> >> >: > numeric expression and store the result in the table. You
> >> need to put '
> >> >> >: > around the value you want to store.
> >> >> >: >
> >> >> >: > Cheers
> >> >> >: > Ken
> >> >> >
> >> >> >
> >> >> >
> >> >> $subst('Email.Unsub').
> >> >> >
> >> >>
> >> >> --
> >> >> Danny Njuguna
> >> >> --
> >> >>
> >> >> $subst('Email.Unsub').
> >> >
> >> >
> >> $subst('Email.Unsub').
> >> >
> >>
> >> --
> >> Danny Njuguna
> >> --
> >>
> >> $subst('Email.Unsub').
> >>
> >
> >
> $subst('Email.Unsub').
> >
>
> --
> Danny Njuguna
> --
>
> $subst('Email.Unsub').
>
Message #20 by "Kim Iwan Hansen" <kimiwan@k...> on Sat, 22 Dec 2001 14:47:06 +0100
|
|
check the number of apostrophes in the example in the previous post and
compare it to what you actually wrote in your own sql string.
it doesn't harm to double-check what you do ;)
-Kim
> -----Original Message-----
> From: Daniel Njuguna [mailto:danny@n...]
> Sent: 22. december 2001 14:18
> To: ASP Databases
> Subject: [asp_databases] Re: odbc error division by zero
>
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in string
> in query expression '1/0')'.
>
> this is the error i get now.
>
>
> ---------- Original Message ----------------------------------
> From: "Kim Iwan Hansen" <kimiwan@k...>
> Reply-To: "ASP Databases" <asp_databases@p...>
> Date: Sat, 22 Dec 2001 14:02:21 +0100
>
> >...,hooksize)... ...,'" & acart(i,2) & "')"
> >
> >you want to put '' around the value you're inserting - not
> around the field
> >name.
> >
> >-Kim
> >
> >
> >> -----Original Message-----
> >> From: Daniel Njuguna [mailto:danny@n...]
> >> Sent: 22. december 2001 12:56
> >> To: ASP Databases
> >> Subject: [asp_databases] Re: odbc error division by zero
> >>
> >>
> >> Hi
> >> how am i supposed to write it so that i can input a text field
> >> into the database without doing a mathematical calculation.
> >>
> >>
> >> ---------- Original Message ----------------------------------
> >> From: "Tomm Matthis" <matthis@b...>
> >> Reply-To: "ASP Databases" <asp_databases@p...>
> >> Date: Fri, 21 Dec 2001 09:52:20 -0500
> >>
> >> >Why is the fieldname hooksize in single quotes inside the string?
> >> >
> >> >-- Tomm
> >> >
> >> >> -----Original Message-----
> >> >> From: Daniel Njuguna [mailto:danny@n...]
> >> >> Sent: Friday, December 21, 2001 9:38 AM
> >> >> To: ASP Databases
> >> >> Subject: [asp_databases] Re: odbc error division by zero
> >> >>
> >> >>
> >> >> I still have my field name as hooksize in the database , the SQL
> >> >> statement is as follows
> >> >>
> >> >> sql= "insert into orderitems
> >> >> (orderid,productid,qty,priceperunit,'hooksize') values (" & orderid
> >> >> & "," & acart(i,0) & "," & acart(i,1) & "," & currentprice & "," &
> >> >> acart(i,2) & ")"
> >> >> set rsorderitems=db.execute(sql)
> >> >>
> >> >>
> >> >>
> >> >> ---------- Original Message ----------------------------------
> >> >> From: "Ken Schaefer" <ken@a...>
> >> >> Reply-To: "ASP Databases" <asp_databases@p...>
> >> >> Date: Fri, 21 Dec 2001 12:30:53 +1100
> >> >>
> >> >> >So what is your SQL Statement now? Do you have a field called
> >> "hooksize" in
> >> >> >the table in question?
> >> >> >
> >> >> >Cheers
> >> >> >Ken
> >> >> >
> >> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >> >> >From: "danny njuguna" <danny@n...>
> >> >> >Subject: [asp_databases] Re: odbc error division by zero
> >> >> >
> >> >> >
> >> >> >: [Microsoft][ODBC Microsoft Access Driver] The INSERT
> INTO statement
> >> >> >: contains the following unknown field name: ''hooksize''.
> >> Make sure you
> >> >> >: have typed the name correctly, and try the operation again.
> >> >> >:
> >> >> >: This is the Error it gives me now.
> >> >> >:
> >> >> >: danny
> >> >> >:
> >> >> >:
> >> >> >: > IIRC In your original SQL statement that you posted, you
> >> did not put '
> >> >> >: marks
> >> >> >: > around the text value. So the database thinks that you
> >> want to evaluate
> >> >> >a
> >> >> >: > numeric expression and store the result in the table. You
> >> need to put '
> >> >> >: > around the value you want to store.
> >> >> >: >
> >> >> >: > Cheers
> >> >> >: > Ken
> >> >> >
> >> >> >
> >> >> >
> >> >> $subst('Email.Unsub').
> >> >> >
> >> >>
> >> >> --
> >> >> Danny Njuguna
> >> >> --
> >> >>
> >> >> $subst('Email.Unsub').
> >> >
> >> >
> >> $subst('Email.Unsub').
> >> >
> >>
> >> --
> >> Danny Njuguna
> >> --
> >>
> >> $subst('Email.Unsub').
> >>
> >
> >
> $subst('Email.Unsub').
> >
>
> --
> Danny Njuguna
> --
>
> $subst('Email.Unsub').
>
Message #21 by "Daniel Njuguna" <danny@n...> on Sat, 22 Dec 2001 16:48:00 +0300
|
|
& acart(i,2) & "')"
This is what i have on the sql string.Is that right.
Thanks
Danny
---------- Original Message ----------------------------------
From: "Kim Iwan Hansen" <kimiwan@k...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date: Sat, 22 Dec 2001 14:47:06 +0100
>check the number of apostrophes in the example in the previous post and
>compare it to what you actually wrote in your own sql string.
>
>it doesn't harm to double-check what you do ;)
>
>-Kim
>
>
>
>
>> -----Original Message-----
>> From: Daniel Njuguna [mailto:danny@n...]
>> Sent: 22. december 2001 14:18
>> To: ASP Databases
>> Subject: [asp_databases] Re: odbc error division by zero
>>
>>
>> [Microsoft][ODBC Microsoft Access Driver] Syntax error in string
>> in query expression '1/0')'.
>>
>> this is the error i get now.
>>
>>
>> ---------- Original Message ----------------------------------
>> From: "Kim Iwan Hansen" <kimiwan@k...>
>> Reply-To: "ASP Databases" <asp_databases@p...>
>> Date: Sat, 22 Dec 2001 14:02:21 +0100
>>
>> >...,hooksize)... ...,'" & acart(i,2) & "')"
>> >
>> >you want to put '' around the value you're inserting - not
>> around the field
>> >name.
>> >
>> >-Kim
>> >
>> >
>> >> -----Original Message-----
>> >> From: Daniel Njuguna [mailto:danny@n...]
>> >> Sent: 22. december 2001 12:56
>> >> To: ASP Databases
>> >> Subject: [asp_databases] Re: odbc error division by zero
>> >>
>> >>
>> >> Hi
>> >> how am i supposed to write it so that i can input a text field
>> >> into the database without doing a mathematical calculation.
>> >>
>> >>
>> >> ---------- Original Message ----------------------------------
>> >> From: "Tomm Matthis" <matthis@b...>
>> >> Reply-To: "ASP Databases" <asp_databases@p...>
>> >> Date: Fri, 21 Dec 2001 09:52:20 -0500
>> >>
>> >> >Why is the fieldname hooksize in single quotes inside the string?
>> >> >
>> >> >-- Tomm
>> >> >
>> >> >> -----Original Message-----
>> >> >> From: Daniel Njuguna [mailto:danny@n...]
>> >> >> Sent: Friday, December 21, 2001 9:38 AM
>> >> >> To: ASP Databases
>> >> >> Subject: [asp_databases] Re: odbc error division by zero
>> >> >>
>> >> >>
>> >> >> I still have my field name as hooksize in the database , the SQL
>> >> >> statement is as follows
>> >> >>
>> >> >> sql= "insert into orderitems
>> >> >> (orderid,productid,qty,priceperunit,'hooksize') values (" & orderid
>> >> >> & "," & acart(i,0) & "," & acart(i,1) & "," & currentprice & "," &
>> >> >> acart(i,2) & ")"
>> >> >> set rsorderitems=db.execute(sql)
>> >> >>
>> >> >>
>> >> >>
>> >> >> ---------- Original Message ----------------------------------
>> >> >> From: "Ken Schaefer" <ken@a...>
>> >> >> Reply-To: "ASP Databases" <asp_databases@p...>
>> >> >> Date: Fri, 21 Dec 2001 12:30:53 +1100
>> >> >>
>> >> >> >So what is your SQL Statement now? Do you have a field called
>> >> "hooksize" in
>> >> >> >the table in question?
>> >> >> >
>> >> >> >Cheers
>> >> >> >Ken
>> >> >> >
>> >> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> >> >> >From: "danny njuguna" <danny@n...>
>> >> >> >Subject: [asp_databases] Re: odbc error division by zero
>> >> >> >
>> >> >> >
>> >> >> >: [Microsoft][ODBC Microsoft Access Driver] The INSERT
>> INTO statement
>> >> >> >: contains the following unknown field name: ''hooksize''.
>> >> Make sure you
>> >> >> >: have typed the name correctly, and try the operation again.
>> >> >> >:
>> >> >> >: This is the Error it gives me now.
>> >> >> >:
>> >> >> >: danny
>> >> >> >:
>> >> >> >:
>> >> >> >: > IIRC In your original SQL statement that you posted, you
>> >> did not put '
>> >> >> >: marks
>> >> >> >: > around the text value. So the database thinks that you
>> >> want to evaluate
>> >> >> >a
>> >> >> >: > numeric expression and store the result in the table. You
>> >> need to put '
>> >> >> >: > around the value you want to store.
>> >> >> >: >
>> >> >> >: > Cheers
>> >> >> >: > Ken
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> $subst('Email.Unsub').
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> Danny Njuguna
>> >> >> --
>> >> >>
>> >> >> $subst('Email.Unsub').
>> >> >
>> >> >
>> >> $subst('Email.Unsub').
>> >> >
>> >>
>> >> --
>> >> Danny Njuguna
>> >> --
>> >>
>> >> $subst('Email.Unsub').
>> >>
>> >
>> >
>> $subst('Email.Unsub').
>> >
>>
>> --
>> Danny Njuguna
>> --
>>
>> $subst('Email.Unsub').
>>
>
>
>
--
Danny Njuguna
--
Message #22 by "Kim Iwan Hansen" <kimiwan@k...> on Sat, 22 Dec 2001 17:58:06 +0100
|
|
*double-check* is the keyword
>> >...,hooksize)... ...,'" & acart(i,2) & "')"
>> >
>> >you want to put '' around the value you're inserting - not
>> around the field
>> >name.
see the apostrophe to the left of " & acart..." ?
you need to put '' *around* the string, not just add it to the end of the
string.
...'" & acart(i,2) & "')"
-Kim
> -----Original Message-----
> From: Daniel Njuguna [mailto:danny@n...]
> Sent: 22. december 2001 14:48
> To: ASP Databases
> Subject: [asp_databases] Re: odbc error division by zero
>
>
> & acart(i,2) & "')"
>
> This is what i have on the sql string.Is that right.
>
> Thanks
> Danny
>
>
>
> ---------- Original Message ----------------------------------
> From: "Kim Iwan Hansen" <kimiwan@k...>
> Reply-To: "ASP Databases" <asp_databases@p...>
> Date: Sat, 22 Dec 2001 14:47:06 +0100
>
> >check the number of apostrophes in the example in the previous post and
> >compare it to what you actually wrote in your own sql string.
> >
> >it doesn't harm to double-check what you do ;)
> >
> >-Kim
> >
> >
> >
> >
> >> -----Original Message-----
> >> From: Daniel Njuguna [mailto:danny@n...]
> >> Sent: 22. december 2001 14:18
> >> To: ASP Databases
> >> Subject: [asp_databases] Re: odbc error division by zero
> >>
> >>
> >> [Microsoft][ODBC Microsoft Access Driver] Syntax error in string
> >> in query expression '1/0')'.
> >>
> >> this is the error i get now.
> >>
> >>
> >> ---------- Original Message ----------------------------------
> >> From: "Kim Iwan Hansen" <kimiwan@k...>
> >> Reply-To: "ASP Databases" <asp_databases@p...>
> >> Date: Sat, 22 Dec 2001 14:02:21 +0100
> >>
> >> >...,hooksize)... ...,'" & acart(i,2) & "')"
> >> >
> >> >you want to put '' around the value you're inserting - not
> >> around the field
> >> >name.
> >> >
> >> >-Kim
> >> >
> >> >
> >> >> -----Original Message-----
> >> >> From: Daniel Njuguna [mailto:danny@n...]
> >> >> Sent: 22. december 2001 12:56
> >> >> To: ASP Databases
> >> >> Subject: [asp_databases] Re: odbc error division by zero
> >> >>
> >> >>
> >> >> Hi
> >> >> how am i supposed to write it so that i can input a text field
> >> >> into the database without doing a mathematical calculation.
> >> >>
> >> >>
> >> >> ---------- Original Message ----------------------------------
> >> >> From: "Tomm Matthis" <matthis@b...>
> >> >> Reply-To: "ASP Databases" <asp_databases@p...>
> >> >> Date: Fri, 21 Dec 2001 09:52:20 -0500
> >> >>
> >> >> >Why is the fieldname hooksize in single quotes inside the string?
> >> >> >
> >> >> >-- Tomm
> >> >> >
> >> >> >> -----Original Message-----
> >> >> >> From: Daniel Njuguna [mailto:danny@n...]
> >> >> >> Sent: Friday, December 21, 2001 9:38 AM
> >> >> >> To: ASP Databases
> >> >> >> Subject: [asp_databases] Re: odbc error division by zero
> >> >> >>
> >> >> >>
> >> >> >> I still have my field name as hooksize in the database , the SQL
> >> >> >> statement is as follows
> >> >> >>
> >> >> >> sql= "insert into orderitems
> >> >> >> (orderid,productid,qty,priceperunit,'hooksize') values
> (" & orderid
> >> >> >> & "," & acart(i,0) & "," & acart(i,1) & "," &
> currentprice & "," &
> >> >> >> acart(i,2) & ")"
> >> >> >> set rsorderitems=db.execute(sql)
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> ---------- Original Message ----------------------------------
> >> >> >> From: "Ken Schaefer" <ken@a...>
> >> >> >> Reply-To: "ASP Databases" <asp_databases@p...>
> >> >> >> Date: Fri, 21 Dec 2001 12:30:53 +1100
> >> >> >>
> >> >> >> >So what is your SQL Statement now? Do you have a field called
> >> >> "hooksize" in
> >> >> >> >the table in question?
> >> >> >> >
> >> >> >> >Cheers
> >> >> >> >Ken
> >> >> >> >
> >> >> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >> >> >> >From: "danny njuguna" <danny@n...>
> >> >> >> >Subject: [asp_databases] Re: odbc error division by zero
> >> >> >> >
> >> >> >> >
> >> >> >> >: [Microsoft][ODBC Microsoft Access Driver] The INSERT
> >> INTO statement
> >> >> >> >: contains the following unknown field name: ''hooksize''.
> >> >> Make sure you
> >> >> >> >: have typed the name correctly, and try the operation again.
> >> >> >> >:
> >> >> >> >: This is the Error it gives me now.
> >> >> >> >:
> >> >> >> >: danny
> >> >> >> >:
> >> >> >> >:
> >> >> >> >: > IIRC In your original SQL statement that you posted, you
> >> >> did not put '
> >> >> >> >: marks
> >> >> >> >: > around the text value. So the database thinks that you
> >> >> want to evaluate
> >> >> >> >a
> >> >> >> >: > numeric expression and store the result in the table. You
> >> >> need to put '
> >> >> >> >: > around the value you want to store.
> >> >> >> >: >
> >> >> >> >: > Cheers
> >> >> >> >: > Ken
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> $subst('Email.Unsub').
> >> >> >> >
> >> >> >>
> >> >> >> --
> >> >> >> Danny Njuguna
> >> >> >> --
> >> >> >>
> >> >> >> $subst('Email.Unsub').
> >> >> >
> >> >> >
> >> >> $subst('Email.Unsub').
> >> >> >
> >> >>
> >> >> --
> >> >> Danny Njuguna
> >> >> --
> >> >>
> >> >> $subst('Email.Unsub').
> >> >>
> >> >
> >> >
> >> $subst('Email.Unsub').
> >> >
> >>
> >> --
> >> Danny Njuguna
> >> --
> >>
> >> $subst('Email.Unsub').
> >>
> >
> >
> $subst('Email.Unsub').
> >
>
> --
> Danny Njuguna
> --
>
> $subst('Email.Unsub').
>
Message #23 by "Daniel Njuguna" <danny@n...> on Mon, 24 Dec 2001 10:51:00 +0300
|
|
Hi
sql= "insert into orderitems (orderid,productid,qty,priceperunit,hooksize) values (" & orderid & "," & acart(i,0) &
"," & acart(i,1) & "," & currentprice & "," & "'" & acart(i,2) & "')"
i added an extra & after the currentprice and put the apostrophe that seems to have done the trick thanks alot for your time and
patience i appreciate it .Happy holidays to everyone.
danny
---------- Original Message ----------------------------------
From: "Kim Iwan Hansen" <kimiwan@k...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date: Sat, 22 Dec 2001 17:58:06 +0100
>*double-check* is the keyword
>
>>> >...,hooksize)... ...,'" & acart(i,2) & "')"
>>> >
>>> >you want to put '' around the value you're inserting - not
>>> around the field
>>> >name.
>
>see the apostrophe to the left of " & acart..." ?
>
>you need to put '' *around* the string, not just add it to the end of the
>string.
>
>...'" & acart(i,2) & "')"
>
>-Kim
>
>
>
>> -----Original Message-----
>> From: Daniel Njuguna [mailto:danny@n...]
>> Sent: 22. december 2001 14:48
>> To: ASP Databases
>> Subject: [asp_databases] Re: odbc error division by zero
>>
>>
>> & acart(i,2) & "')"
>>
>> This is what i have on the sql string.Is that right.
>>
>> Thanks
>> Danny
>>
>>
>>
>> ---------- Original Message ----------------------------------
>> From: "Kim Iwan Hansen" <kimiwan@k...>
>> Reply-To: "ASP Databases" <asp_databases@p...>
>> Date: Sat, 22 Dec 2001 14:47:06 +0100
>>
>> >check the number of apostrophes in the example in the previous post and
>> >compare it to what you actually wrote in your own sql string.
>> >
>> >it doesn't harm to double-check what you do ;)
>> >
>> >-Kim
>> >
>> >
>> >
>> >
>> >> -----Original Message-----
>> >> From: Daniel Njuguna [mailto:danny@n...]
>> >> Sent: 22. december 2001 14:18
>> >> To: ASP Databases
>> >> Subject: [asp_databases] Re: odbc error division by zero
>> >>
>> >>
>> >> [Microsoft][ODBC Microsoft Access Driver] Syntax error in string
>> >> in query expression '1/0')'.
>> >>
>> >> this is the error i get now.
>> >>
>> >>
>> >> ---------- Original Message ----------------------------------
>> >> From: "Kim Iwan Hansen" <kimiwan@k...>
>> >> Reply-To: "ASP Databases" <asp_databases@p...>
>> >> Date: Sat, 22 Dec 2001 14:02:21 +0100
>> >>
>> >> >...,hooksize)... ...,'" & acart(i,2) & "')"
>> >> >
>> >> >you want to put '' around the value you're inserting - not
>> >> around the field
>> >> >name.
>> >> >
>> >> >-Kim
>> >> >
>> >> >
>> >> >> -----Original Message-----
>> >> >> From: Daniel Njuguna [mailto:danny@n...]
>> >> >> Sent: 22. december 2001 12:56
>> >> >> To: ASP Databases
>> >> >> Subject: [asp_databases] Re: odbc error division by zero
>> >> >>
>> >> >>
>> >> >> Hi
>> >> >> how am i supposed to write it so that i can input a text field
>> >> >> into the database without doing a mathematical calculation.
>> >> >>
>> >> >>
>> >> >> ---------- Original Message ----------------------------------
>> >> >> From: "Tomm Matthis" <matthis@b...>
>> >> >> Reply-To: "ASP Databases" <asp_databases@p...>
>> >> >> Date: Fri, 21 Dec 2001 09:52:20 -0500
>> >> >>
>> >> >> >Why is the fieldname hooksize in single quotes inside the string?
>> >> >> >
>> >> >> >-- Tomm
>> >> >> >
>> >> >> >> -----Original Message-----
>> >> >> >> From: Daniel Njuguna [mailto:danny@n...]
>> >> >> >> Sent: Friday, December 21, 2001 9:38 AM
>> >> >> >> To: ASP Databases
>> >> >> >> Subject: [asp_databases] Re: odbc error division by zero
>> >> >> >>
>> >> >> >>
>> >> >> >> I still have my field name as hooksize in the database , the SQL
>> >> >> >> statement is as follows
>> >> >> >>
>> >> >> >> sql= "insert into orderitems
>> >> >> >> (orderid,productid,qty,priceperunit,'hooksize') values
>> (" & orderid
>> >> >> >> & "," & acart(i,0) & "," & acart(i,1) & "," &
>> currentprice & "," &
>> >> >> >> acart(i,2) & ")"
>> >> >> >> set rsorderitems=db.execute(sql)
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> ---------- Original Message ----------------------------------
>> >> >> >> From: "Ken Schaefer" <ken@a...>
>> >> >> >> Reply-To: "ASP Databases" <asp_databases@p...>
>> >> >> >> Date: Fri, 21 Dec 2001 12:30:53 +1100
>> >> >> >>
>> >> >> >> >So what is your SQL Statement now? Do you have a field called
>> >> >> "hooksize" in
>> >> >> >> >the table in question?
>> >> >> >> >
>> >> >> >> >Cheers
>> >> >> >> >Ken
>> >> >> >> >
>> >> >> >> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> >> >> >> >From: "danny njuguna" <danny@n...>
>> >> >> >> >Subject: [asp_databases] Re: odbc error division by zero
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >: [Microsoft][ODBC Microsoft Access Driver] The INSERT
>> >> INTO statement
>> >> >> >> >: contains the following unknown field name: ''hooksize''.
>> >> >> Make sure you
>> >> >> >> >: have typed the name correctly, and try the operation again.
>> >> >> >> >:
>> >> >> >> >: This is the Error it gives me now.
>> >> >> >> >:
>> >> >> >> >: danny
>> >> >> >> >:
>> >> >> >> >:
>> >> >> >> >: > IIRC In your original SQL statement that you posted, you
>> >> >> did not put '
>> >> >> >> >: marks
>> >> >> >> >: > around the text value. So the database thinks that you
>> >> >> want to evaluate
>> >> >> >> >a
>> >> >> >> >: > numeric expression and store the result in the table. You
>> >> >> need to put '
>> >> >> >> >: > around the value you want to store.
>> >> >> >> >: >
>> >> >> >> >: > Cheers
>> >> >> >> >: > Ken
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >> $subst('Email.Unsub').
>> >> >> >> >
>> >> >> >>
>> >> >> >> --
>> >> >> >> Danny Njuguna
>> >> >> >> --
>> >> >> >>
>> >> >> >> $subst('Email.Unsub').
>> >> >> >
>> >> >> >
>> >> >> $subst('Email.Unsub').
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> Danny Njuguna
>> >> >> --
>> >> >>
>> >> >> $subst('Email.Unsub').
>> >> >>
>> >> >
>> >> >
>> >> $subst('Email.Unsub').
>> >> >
>> >>
>> >> --
>> >> Danny Njuguna
>> >> --
>> >>
>> >> $subst('Email.Unsub').
>> >>
>> >
>> >
>> $subst('Email.Unsub').
>> >
>>
>> --
>> Danny Njuguna
>> --
>>
>> $subst('Email.Unsub').
>>
>
>
>
--
Danny Njuguna
--
|
|
|
View Cart
