Hi Imar
The last database connection was sorted as you told me .
now i have a problem updating Records .
the Error is the deleteEvents.asp whic is
' Open the connection
    objConnection.Open.    everything is working well on this last

Thanks Imar

Adam

Hi Adam,

I am not sure I understand this post. You have a problem with the deleteEvents page and then what? Do you get an error? If so, what error? Does the page run at all?
Can you post some of the code, if you think that might help?

And how did you solve the previous problem? Was it a permissions issue?

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: High speed by Coldplay (Track 8 from the album: Parachutes) What's This?

Hi Imar

1)I solved the problem (Database Connection)in the last post http://p2p.wrox.com/topic.asp?TOPIC_ID=12896 byt setting the permission access to IUSR_machineName for the database folder.
so was all about the permission issue as you told me to check .
but i have noticed that on the the Book of "the begenning dreamweaver mx " page 530 on the Add a second Recordset was named rsEvent and not rsEvents as at the end the page didnt work so i recreated it again but this time i named it rsEvents and from there all pages were runing .

Thanks for your patient

2)Regarding this Topic Updating Database i have just realised that i typed a wrong code connection.

i'm working with differant database connection string which is :


instead of typing the right code connection for my website(connweb) i typed the :

now i can delete and can update ..Silly me :D

Ohh Lots of connections :)

will get you drink once you in london :)

have a nice day Imar

Regards
Adam

I just checked the book and I am not sure what you mean. In step 1 through 14, rsEvent is used (singular form, as only one event is updated at the same time). Step 15 through 17 use rsEvents because on showEvents.asp a list of (multiple) events is displayed.
Where did you mix the names? Is there an error in the book somewhere that I overlooked or did you mix up the names?
In the first case, can you let me know what and where it is incorrect?

Should have known about that drink offer. I was in London last week ;)

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hello again

I believe you right i think i did a mistake when i had a connection problem that why i used the rsEvents ,but is it ok if i leave the rsEvents for the update page or do i have to change it ?
at the moment i can update 1 event at time and all pages are working .

let me know when next you in london

Regards

Adam

The actual name really doesn't matter. You could also name the recordset rsIRatherDrinkBeerThanProgramASP if you'd want. I have chosen the name rsEvent to indicate that the recordset is going to hold only one event on the Update page. The showEvents page will list multiple events, so the recordset on that page is called rsEvents.

What's important is how you defined the recordsets on the page. For the update page you should have a categories and an event recordset. If the page works as expected, I am sure the rest is fine as well.

Cheers,

Imar
 ---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.