things to watch for: text strings that are greater than the limit on a
column (i.e. trying to insert a 100 char string into a varchar(50)) will
need to be trimmed to length first if you don't want to throw an error.
with Access I think it just truncated the string automatically.
also things like concatenating strings is totally different
Jolly Green
Giant To: <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
dstoy.com> Subject: [ cf-dev ] SQL compared to
Access backend
01/07/2004
01:39
Please respond
to dev
So how different is your code when your backend is SQL Server rather than
Access? I've worked in Access for 4 years. What can I expect to be
different if I want to work in SQL? Most simple queries will stay the
same, won't they?
I know some functions may change, but what else?
Thanks!
David /jgg
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
