Setting Up a Form-

[improvcornartist]

Can you connect to the database using the include file?

[jhardman]

my boss emailed me this

you're connecting to a table on the SQL server, which is called sutherlands_mai ling_list, not an access database. Look at the data entry pages on www.sutherlands homedesigncente r.com/manager to see how to connect. Your connection string is already built if you use the file include 'database_conne ct' - you basically just have to write a simple SQL INSERT statement.

I'm still confused between 1- what is the name of the db file 2- what is the name of the dsn 3- what is the name of the table? I guess if this is on sql server than you really need to know 2 and 3 and you need to connect using the dsn.

What do the magical files on /manager say?

By the way, I looked into the problem with being banned. The mod who banned you has not yet responded.

Jared

[jhardman]

my boss emailed me this

you're connecting to a table on the SQL server, which is called sutherlands_mai ling_list, not an access database. Look at the data entry pages on www.sutherlands homedesigncente r.com/manager to see how to connect. Your connection string is already built if you use the file include 'database_conne ct' - you basically just have to write a simple SQL INSERT statement.

Actually, now that makes a lot of sense. The connection command is in the include file, so your boss doesn't even know what the dsn is. I'm afraid you will have to use the include file and follow the lead of the other data entry pages.

I would like to caution, however, to not use "INSERT". There are a lot of things that can happen to cause an ado connection to error, and if you split up the insert command into "SELECT", "addnew", and "update" this will give you a better idea where a problem is if and when you find one.

This would go something like this:
[code=asp]query = "SELECT * FROM sutherlands_mai ling_list"
rs.open query, conn, 2, 3

rs.addnew
for each x in rs.fields
if request.form(x) <> "" then
rs(x) = request.form(x)
end if
next
rs.update[/code]Let me know if this helps.

Jared

(by the way, thank you for getting me my 500th post)

[theimmortalmoo]

hey thanks guys got it working! woot, thanks for your help it has a diffrent address than before,

ALSO

why did i get banned, ne one know?

http://www.webice.net/join.asp

[jhardman]

why did i get banned, ne one know?

I couldn't find a reason. The mod who banned you did post in one thread with you, it was a non-technical thread, I think in the games and puzzles forum. I pm'd him and didn't get a response.

I think it was probably on accident though, because every offense I can think of that would warrant a permanent ban also requires that at least some posts be deleted. See any posts deleted?

Jared

[kestrel]

I couldn't find a reason. The mod who banned you did post in one thread with you, it was a non-technical thread, I think in the games and puzzles forum. I pm'd him and didn't get a response.

I think it was probably on accident though, because every offense I can think of that would warrant a permanent ban also requires that at least some posts be deleted. See any posts deleted?

Jared

I banned you because of your post in the Flash Articles Section. Please do not post ads under any circumstances. Please read the FAQ regarding posting guidelines before you post anything again.

Your post in the Flash Articles Section was deleted.

--
Kestrel

[theimmortalmoo]

Wasnt Trying to advertise, was just letting people know what could help :/


sorry about that.

Thoes are the sites i use, if i needed help with it :/

[kestrel]

Wasnt Trying to advertise, was just letting people know what could help :/


sorry about that.

Thoes are the sites i use, if i needed help with it :/

I understand. You found the right thread to post flash links. So if you have any more just place them there. Thanks for your help.