dtolo
asked on
Question Continued from previous class registration question
RCMB,
Your code works great! On minor issue (I am sure that solve it once I have a good look at it, but I wanted to keep the dialog going because I am learning an incredible amount from this) I get a no records returned message, even though the table update works perfectly.
I noticed that the last submit if the user wants to register for the class (nice touch) submits the inf to page 3 - which I
Can code to forward to the final page so this is no big deal. The question is more from curiosity. Why does page 3, if not allowed to redirect, still give a no records returned message.
I am continuing this if you are interested at all in tweeking this process a little more. If not I am very gratefull, and what I have is more than enough.
~David
Your code works great! On minor issue (I am sure that solve it once I have a good look at it, but I wanted to keep the dialog going because I am learning an incredible amount from this) I get a no records returned message, even though the table update works perfectly.
I noticed that the last submit if the user wants to register for the class (nice touch) submits the inf to page 3 - which I
Can code to forward to the final page so this is no big deal. The question is more from curiosity. Why does page 3, if not allowed to redirect, still give a no records returned message.
I am continuing this if you are interested at all in tweeking this process a little more. If not I am very gratefull, and what I have is more than enough.
~David
ASKER
rcmb,
This all works excellent and has helped me out a lot.
If I am at a page that links to this page that you created,
Is it possible to pass values to your page from the linking page?
Say maybe in the url (or a variable or someting)
The point is that I would like to populate two more fields (and maybey more in the future) specifically:
ClassName
DaysAndTimes
This is from a sharepoint calendar that connects to the pages that you created. If possible in the link or some variable stored on the aspx page, I would like pass this information to the page that adds the new records to the register table.
Do you understand what I mean?
If at any point I get to anoying by all of my requests, please let me know and I will gladly stop bugging you. Also if I should ask any new questions and close the current one out, let me know that too. there are several more things that i have to do before this piece of the intranet site i am builiding is done.
You have been a tremendous help.
~David
This all works excellent and has helped me out a lot.
If I am at a page that links to this page that you created,
Is it possible to pass values to your page from the linking page?
Say maybe in the url (or a variable or someting)
The point is that I would like to populate two more fields (and maybey more in the future) specifically:
ClassName
DaysAndTimes
This is from a sharepoint calendar that connects to the pages that you created. If possible in the link or some variable stored on the aspx page, I would like pass this information to the page that adds the new records to the register table.
Do you understand what I mean?
If at any point I get to anoying by all of my requests, please let me know and I will gladly stop bugging you. Also if I should ask any new questions and close the current one out, let me know that too. there are several more things that i have to do before this piece of the intranet site i am builiding is done.
You have been a tremendous help.
~David
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Now with all of that said if you desire to pass via the URL then at some point you will have to populate the URL. If you are coming from a form then the best way to do this is in my previous example.
To get data from a URL your URL would look like:
page1.asp?ClassName=123456
Then in page1.asp where I did request.form change it to read request.querysting in the first form only. This is because after you select your employee number you will pass form data to the second form so you will not desire to use request.querystring.
R/Curtis
To get data from a URL your URL would look like:
page1.asp?ClassName=123456
Then in page1.asp where I did request.form change it to read request.querysting in the first form only. This is because after you select your employee number you will pass form data to the second form so you will not desire to use request.querystring.
R/Curtis
ASKER
I like your first example best. I am not quite sure how sharepoint calendars work. If i could grab the daytime, ClassName information from the sharepoint calendar (It is automatically generated so I am not quite sure how to get it - but I know at least the day time must) and store it in variables then pass those to page one (which i named default.asp) It would be Ideal
These guys won't let me into the SQL server that the sharepoint site is sitting on - Otherwise I would just link up my database.
These guys won't let me into the SQL server that the sharepoint site is sitting on - Otherwise I would just link up my database.
How do you plan to link from the calendar to default.asp?
Generate a calendar in IE and take a look at the source code of the calendar page and you have be able to figure out just how the data is being generated. You could probably at least see what information is presented.
From what you are saying the URL may be best if the calendar is generated from a SQL database then you can probably create a link to default.asp from the calendar and have something like:
default.asp?ClassName=<%=f
The field information ("<%=fp_rs("ClassName")%>"
Curtis
Generate a calendar in IE and take a look at the source code of the calendar page and you have be able to figure out just how the data is being generated. You could probably at least see what information is presented.
From what you are saying the URL may be best if the calendar is generated from a SQL database then you can probably create a link to default.asp from the calendar and have something like:
default.asp?ClassName=<%=f
The field information ("<%=fp_rs("ClassName")%>"
Curtis
ASKER
I am revamping the intranet site for the State of Connecticut. They don't actually submit the values to sign up for a class, I am trying to make this as uncomplicated as possible for them. A training instructor creates a new event on a sharepoint calendar (like handcuffing for peobation officers or something) I teach him how to create a link in the events description ( I could have a list of prefabed links I suppose) The end user click on the link to get to the page you created. I am going to get you a list of the field that the calendar uses and get back to you.
Let me know if you have any ideas or questions, or want to see the code.
I am using sts and Frontpage 2003
Let me know if you have any ideas or questions, or want to see the code.
I am using sts and Frontpage 2003
ASKER
I will check out what you said and look at it tommarow. I have to head home.
have a great day and try not to fall asleep over there. :-)
~David
have a great day and try not to fall asleep over there. :-)
~David
ASKER
The server is wss not sts
ASKER
I actually us two servers for the site. one with regular fp2002 extensions. (this is the one that I run all of the asp's on)
And the other is wss with sharepoint. So the app starts on the share point server and kicks over to the fp2002 for the reg. piece.
And the other is wss with sharepoint. So the app starts on the share point server and kicks over to the fp2002 for the reg. piece.
ASKER
I think that this site might tell us how to do it http://www.oakleaf.ws/wsslistsasp/AboutListUpdates.aspx
I have been away this morning (went fishing !!!). I do not have a lot of experience in the SharePoint area other than creating a few sites. I have not really done any coding in this area but from what I have seen if you can figure out how the link is generated then you should be able to pass the data to the other site via the query string.
If you desire you can close this question out and contact me @ rcmb25@bellsouth.net.
R/Curtis
If you desire you can close this question out and contact me @ rcmb25@bellsouth.net.
R/Curtis
ASKER
OK,
Will do.
Will do.
ASKER
Curtis,
I wont be at work till monday and our mail can only be answered internally. I was in a hurry to get that app over to my supervisory, so I did,nt really get the chance to thank you the way I should have.
You really went the extra mile, and I am eternally gratefull. I hope you and your family (especially your daughter who I hope get well soon) are blessed in many many ways.
You are an extraordinarry person, and an amazing programer.
Have a wonderfull birthday!!
Your friend...
~David
I wont be at work till monday and our mail can only be answered internally. I was in a hurry to get that app over to my supervisory, so I did,nt really get the chance to thank you the way I should have.
You really went the extra mile, and I am eternally gratefull. I hope you and your family (especially your daughter who I hope get well soon) are blessed in many many ways.
You are an extraordinarry person, and an amazing programer.
Have a wonderfull birthday!!
Your friend...
~David
To correct this problem simply open page 3.
You will see the start of the DBRW -- double click on the start region and it will open the wizard.
Proceed to the step 3 and click on More Options...
In this window you will see the message No records Returned
Simply delete this message or modify to display a message of your choice like :
-- Your registration was successfully recorded --
Then finish the wizard. Note: If you leave the field blank it will work just fine and not display anything on the screen, but if you run the DBRW again FrontPage will automatically put the No Records Returned message back in the box so you will have to delete it to keep the message from displaying. Quite annoying trait in FrontPage :-(.
If you decide to put you own personal message in the box then remove the reidrect and create a hyperlink back to page of your choice. I tend to leave the message blank and have my page redirect but the down side to this is if there is an error the user never knows it and assumes their information was recorded and it was not. Much like what we were seeing when we first started this project.
R/Curtis