- see footer for list info -<
Put <cfqueryparam round all the values and it should give you a data
type validation error if there is one...
i.e. <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#form.packageID#">
Paul Swingewood wrote:
- see footer for list info -<
Hello adrian,
all of the values output correctly ....
The database is like this ...
OrderIDPK int 4 *KEY Identity Seed 1*
OrderDate datetime 8
Dfes nvarchar 50
ContactName nvarchar 50
FocusArea nvarchar 50
PackageIDFK int 4
Quantity int 4
TotalCost money 8
Perhaps its a weirdo with the money datatype ...?
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go
to http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your
help -<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
