[Emerald] integer problem

Michael Strand ( (no email) )
Mon, 17 Jul 2000 21:41:10 +0930

This is a multi-part message in MIME format.

------=_NextPart_000_005D_01BFF037.B8C13300
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
I am trying to get the web sign up working, the SQL server is returning =
integers with decimal places when ID's are requested. eg. GroupID will =
return as 3.00 instead of just 3. This is causing odbc syntax errors on =
the insert to add a customer.

I am not sure how to get around this, can anybody offer some advice?

Michael Strand

------=_NextPart_000_005D_01BFF037.B8C13300
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Hi,
I am trying to get the web sign up =working, the SQL=20server is returning integers with decimal places when ID's are =requested. eg.=20GroupID will return as 3.00 instead of just 3. This is causing odbc =syntax=20errors on the insert to add a customer.
 
I am not sure how to get around this, =can anybody=20offer some advice?
 
Michael Strand
 
------=_NextPart_000_005D_01BFF037.B8C13300--