Brotha',
The answer is, of course, It Depends.
If you used ANSI standard SQL commands in your CFQueries, then your code
should be portable for the most part. If you are using _ANY_ database
functions in your queries, then you've got to check to see if they work in
the new db environment. Seems to me that SQLServer and Access don't always
share function names for functions with similar purposes - Now( ) vs
GetDate??( ), etc.
Another issue which may be more significant is the use of AutoNumber
datatypes for primary keys in Access. [I don't want to pick the scab on
this one; you should be able to find numerous recent postings on the
subject of Primary Keys and Access Autonumber fields, etc. etc. I read
many of the postings but don't recall that the Right Answer(tm) was ever
officially announced. You'll want to refer back to the postings - or start
the whole brou-ha-ha again.] In any case, SQLServer doesn't exactly have
an AutoNumber field, so a different mechanism will have to be identified
for automatically creating PrimaryKeys - if that's what you really want to do.
How's that for a definitive answer? ;-)
Kevin
At 11:54 AM 8/4/00 -0400, you wrote:
>[11:44] <aeon_flux> say, if i have an access db
>[11:44] <aeon_flux> and i import my db in a sql server 7...
>[11:44] <aeon_flux> and change my driver in my odbc setup to point my dsn to
>the sql server db...
>[11:45] <aeon_flux> theoretically.. do i have to change any of my code or do
>CF's drivers take care of it.. like a <CFINSERT> works no matter what type
>of db your working with because it goes through the drivers in ODBC setup?
>
>It's hard to explain what I'm trying to ask... :-) I'm wondering if I
>switch databases, do I have to change any of my code if the db takes my
>tables etc.. in exactly as they were in access?
>
>See in ASP when I used to code ASP, depending on the way you coded you more
>then likely had to change most if not all your code to reflect the new
>database you were working on. You could either use straight SQL, or
>RECORDSETS, etc.. And I'm wondering if that's the same about CF.. I was told
>that you didn't have to change code which is probably the one reason I
>switched. :-)
>
>Thanks and let a brotha know,
>
>jake hileman - 17 year old hoster man, guy, thing.
>www.divineweb.com - ceo. we will be supporting cf veryyyy soon.
--------------------------
Kevin Marshall
Web Application Developer
eCalton.com, Inc.
Vero Beach, FL
www.ecalton.com
[EMAIL PROTECTED]
561.569.4500
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
