| Author |
 Topic  |
|
|
Kristabel
New Member
United Kingdom
83 Posts |
 Posted - 25 March 2001 : 07:52:46
|
I've made various posts regarding this over the last few months...
I want to set up a guestbook so I want a database to store things such as the person's name, email address etc. and also whether or not they want their comments published on the website.
My hoster has set up a DSN for me. I have created the DB. I have created some nice connect.asp and disconnect.asp include files for opening and closing the connection and recordset to be used. I now just need to actually do the SQL for inserting a new entry and then for displaying it.
I know the SQL I want to use to do this. I use SQL all the time at work with no troubles, but that's using SQL Server. Access seems to be different and I have read on the web all sorts of different things, including putting [square brackets] around field names, to putting '%single quotes and percentage signs%' around field names.
Basically, I would just like to be given some examples that work (which I can then just alter according to my DB) or be pointed to somewhere with comprehensive and accurate advice on this!
Thanks in advance. I really hope someone can help me because I've been with this hoster for 3 months and I still haven't been able to do any database work on my site!
'Live, love and learn' |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 25 March 2001 : 11:22:22
|
If you are using snitz forums, I've created a Guestbook that incorperates with it, it includes 3 customizable fields also. http://forum.snitz.com/forum/link.asp?topic_id=6971
Access is pretty much the same as sql server (field wise)
VARCHAR (20) - same
MEMO - text on sql server
INT - same
COUNTER - same as Identity (1, 1) on sql server, I do not believe you can specify the 1, 1 in access though
If you are using Jet 4.0 connection string, you can use the SAME syntax for Access that you use for SQL server, whether its access 97 or access 2000
----------------
Da_Stimulator
Need a Mod?
My Snitz Test Center
|
 |
|
|
Kristabel
New Member
United Kingdom
83 Posts |
Posted - 26 March 2001 : 02:32:08
|
Thanks for that. I'm not using a Snitz forum as yet. I want to create my own guestbook and when (IF!) I get my own DB working I would later like to put a forum on my site. Unfortunately, because my host set up a DSN for me when I asked them about the connection string, I have no idea whether or not it is a Jet 4.0 connection string. You can see the errors I am getting on http://www.hiltonweb.co.uk/guestbook.asp (this page is currently not accessible via the menu). I have emailed the host again about it so I hope to get a response soon!
Thanks again.
'Live, love and learn' |
|
|
| |
Topic |
|
|
|
Topic Locked
