ASP Multiple Selection UPDATE SUPPORT

Will get back with you in a few with the Demo file(s)
Carrzkiss

Hi,

Like posted in previous question, i really would like the database to use two tables link and linksref,

link table that has the url information and linksref table that stores the id's (linkid,pid,ordered)...

please let me know when you have done..

Thank you.

Correct.
I am implementing that right now.
Starting to look good.
Will get back with you after while.

Wayne

hello,

Could you also point me to the right direction, where the insert link order page is, because all i seem to have is the update link..


cheers

Once I get this working I will send you over all the files, plus the updated files
To work with what you need.
And I just ran into another issue, (Same as before)
Trying to get this done for you.
So please have some patients, while I try to sort through and fix the issues.

Thank You
Wayne

Hi,

Is there any progress?

Do you remember the other person that came in on the other question?
He is the one that "Was" helping on the code.
He did fix the issue with the
"Limit" = No More Limit.... Great Right?
BUT.
The code keeps breaking.
Meaning: That every time that I run the code and try to update the records
It does not update the records accordingly.
Basically like this:

If you choose
LinkID       Order
1              4  
5              1      
6              3
9              2

It will do the following:

LinkID       Order
1              4  
5              1      
6              1
9              1

-------
So. I am trying something different.
I am trying to do the following:
<select onchange="">
Make it take the Selected Number and insert it into a Dynamic Type Field.
But, so far no luck.
There is a possible solution, but I will not know until later on today towards the evening Hopefully.

I am so sorry that it is taking so long to do this.
But, this is a difficult issue. It is taking me and a few others on EE and other places to do what you
Are needing.
BUT!!! We will get it done. I promise, I do not give up.
Just give me a little while longer on this please.
I will not disappoint.

Wayne

Sure no problem, good luck in the meantime. Cheers..

Thank you for understanding.
I will not give up, it will get done.
I promise.

Wayne

OK.
(Still have to do some testing on it)

I believe that we might be ready for GO!!!!!!

BUT.
There is a slight problem.
You know how you wanted it to show ALL of the links.
When you go to
Choose.asp
To choose the new links, you wanted to see your Previously selected links as well?
That is going to be a problem.

With everything in a Single Table (Like the example that I last sent to you)
This would be Easy as pie, and worked like a charm. BUT that was using 1 Table.

Using 2 Tables, when you create the Join statement for the Database.
It automatically grabs the ones that are listed.
BUT
As I previously stated.
I will not give up the ghost, I will get it to work.
Just wanted to let you know that I am almost complete with it.

Wayne

Just to make sure we're on the right track, we have two types of sections Insert and Update

Insert - displays all links in the links table and where you can ADD new links to the linksref table (only stores IDs in the linksref table).

Update - Displays selected links (looking at the pageid) aswell as all links in the links table.

I'm developing this in a cms and will be developed this link selection tool on a few pages, that is why i have a seperate table called linksref to collect the id's.

The way i am doing the update bit is, when you select a section you want to edit, it should display all links and should display the selected ones, so u can edit or remove from the selection. All the update looks for is the page id in the querystring. If the querystring (page id) matches the pid in the linksref table then display the selected links, etc... I think you know what i mean.

let me know if you need more clarification.


Faraz.

OK
I think that you clarified enough for me there.
So.
Choose.asp
Is strickly to choose from, and DO NOT show anything from the previous inserted links..
OK.
I will work on the Update, and see if I can make it work the way I need it to.

WIll reply in a few with my findings.
Wayne

I've forgotten what page is what..

Although you should have the following type of pages

1. Insert - A list of links with drop down boxes to choose from and ADD links into the database

2. Update - A list of selected links and to display all links with drop drop down boxes and to update


Faraz

Yep.

It is going to be hard to make this work.
I am going to have to wait until tomorrow before I will be able to start back on it.
I have to get my site up and running this evening, as I am behind on it.

I will let you know something on this sometimes tomorrow.
Maybe I will be able to find some useful resources on it over the night.

have a good evening Faraz
Wayne

cheers.. Its almost 3am here in UK... Have a good evening.. Please do let me knw hw things get on.. Thanks

I GOT IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Yahoooooooooooooooooooooooo
I do not know what to write, except I GOT IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

And it was so simple in the end, that I just cannot believe how simple it was.

OK.
This was the problem that was messing up everything.

UPDATE = You can Update an Existing Record.
You CANNOT Update a Non-existing Record.
BUT
You can INSERT a new Record.

So.
That is what I did,
During the Update Statement, I also made an INSERT Statement as well.

Sending Code over in a few minutes, after I write my notes.

Go YEA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
That is what I am doing in my head right now.
Because everyone else is asleep.

Rock On!!!
(I can't stop rambling, this is AWESOME~!!!!!!!!!!! Man, simply AWESOME!!!!!!!!!!!!!!!!!!)
Wayne

Hello, Thank you for all your help, i will email you later today with my details, I've given up with this, i cant simply get it to work due to my sql server version the webhosting has, i keep getting an error message with the inserting links. I'm going to have to take this bit of from my cms, will do something else.

Although, thank you for everything. It works perfectly on your server.

Small request. Could you please leave the files and database on your server for a few days please, as i want to take some screenshots for future references, please.

thank you


Faraz

Everything is perfect. Quick delivery as promised. Excellent Help. Thank You

what are the errors that you are getting?
&
What is the Server/Hosting company that you are using (or) Going through?

I might be able to help or at least help you do some trouble shooting.

files and site are available here:
http://www.pcitdad.com/Test/EE/Q_24113560/Choose.asp?pid=1
Download
http://www.pcitdad.com/Test/EE/Q_24113560/Q_24113560.zip

Please let me know about the issue(s) that you are having.
I would really like to help you out on this one.

have a good one.
Wayne

I will let you know the issues i am having with this, later this week, another thing i wanted to mention, if you test the update area of this link, you will notice that it does not update the link, it simply adds the link again. Could you please have a look into this.

Kind Regards,
Faraz

Internet keeps messing up over here.

OK.
That is an issue that I did not notice before.
I will have to check in on that one.
I do not have time to do it right now, but will look into it one I do.

yeh cool, no problem, there's no hurry for this one anymore.

I have another question raised, don't know if you an help me on this one.

https://www.experts-exchange.com/questions/24126243/CDONTS-HTML-email-format.html

its about sending HTML emails.

Fixed the project. Now it will
update (Existing Records)
Insert (New Records)
And no more duplicates.

http://www.pcitdad.com/Test/EE/Q_24113560/Choose.asp?pid=1
Download
http://www.pcitdad.com/Test/EE/Q_24113560/Q_24113560.zip

I am trying to add something else to it as well.
I will let you know when that is done.
But, other then that.
It is working flawlessly.
So hopefully you will be able to test it out on your end.

have a good one.
Wayne

Hi Wayne,

I don't think the update is working correctly, I have tried the demo on your link, and the update doesnt seem to work. Could you please test and let me know please. thanx.

it was working last night when I did it.
I will do some more checking.
This is annoying, it worked great last night, and now it want to be a pain.

Will let you know something soon.

no problem, wayne, cheers.

The problem i am having is updating the link to a null value, that is what i have spotted so far, but do let me  know.

thank you Wayne.