FLASH: OT Start in Access is OK

[Chris Tifer]

Sure, you can always start out in Access and then move it on to SQL.  We've

done that on some projects once they started getting large, but just be

aware that in your SQL string, in Access you can say "True" or "False", but

in SQL, we've only found that 1 or 0 works.


Of course Access understands 1 & 0 so just use those values.  Also, if you

have an autonumber, it will become a regular number in SQL, so you will need

to make a minor adjustment there (set identity increment to 1 - I'm going

off memory here, so if I screwed up, sorry)


Anymore questions, fire away.


Chris


-----Original Message-----

From: Renu Vora [

renu_voraemail [dot] msn [dot] com (mailto:renu_voraemail [dot] msn [dot] com)

]

Sent: Monday, December 20, 1999 3:26 PM

To:

flasherchinwag [dot] com

Subject: Re: FLASH: RE: Flash: OT (easier way to link database to

website)



Hi again!


Thanks Chris, Branden & James.

I realise that this needs to be done by a DBA or Programmer

I was wondering if this could be done in Access to

startwith.

When it gets unmanageable then get this done in Oralce/Cold

Fusion.



Has anyone used drumbeat2000? Any suggestion on that?

At this point I am looking for this site to get up & running

in 2-3 months time.

Is there any other software(s) which would get me started

rather easily.

Depending on the sucess/traffic, hiring DBA or programmer

could be considered.


Help is appreciated.

Thanks.

Renu











flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  Streaming Media WEST '99 Conference & Exhibition

  "The Worlds largest Internet Audio & Video Event"

 December 7 - 9, San Jose Convention Center, California


Reserve your space today at http://www.streamingmedia.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com

flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  Streaming Media WEST '99 Conference & Exhibition

  "The Worlds largest Internet Audio & Video Event"

 December 7 - 9, San Jose Convention Center, California


Reserve your space today at http://www.streamingmedia.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com