Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.
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
Asked:
-
9
-
5
1 Solution
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
I think I understand what you desire and no you are not bothering me. I sit in front of this computer about 10 hours a day building websites for the US Navy (I am a contractor to the Navy) and this is always a nice break from the constant coding.
Lets say on page1.asp you need to get the ClassName and DaysAndTimes
If they are coming from a form where the form will submit to page1.asp then all you will need to do in page1.asp is to add something like:
In your existing forms
<input type="hidden" name="DaysAndTime" value="<%=request.form("Da
<input type="hidden" name="ClassName" value="<%=request.form("Cl
since in page1.asp we actually created two forms, the first will list the employee number and second will allow the employee to verify this is actually their employee number, I would put this code in both forms.
What will happen then is the data will be populated from the SharePoint form to the form containing employee numbers and then when you hit submit it will reload page1.asp and populate the second form with the same information. Then when you go to insert into the database just add this data to the sql query like
INSERT INTO Register (...., ClassName, DatesAndTimes) VALUES (...., '::ClassName::', '::DatesAndTimes::')
Curtis
Lets say on page1.asp you need to get the ClassName and DaysAndTimes
If they are coming from a form where the form will submit to page1.asp then all you will need to do in page1.asp is to add something like:
In your existing forms
<input type="hidden" name="DaysAndTime" value="<%=request.form("Da
<input type="hidden" name="ClassName" value="<%=request.form("Cl
since in page1.asp we actually created two forms, the first will list the employee number and second will allow the employee to verify this is actually their employee number, I would put this code in both forms.
What will happen then is the data will be populated from the SharePoint form to the form containing employee numbers and then when you hit submit it will reload page1.asp and populate the second form with the same information. Then when you go to insert into the database just add this data to the sql query like
INSERT INTO Register (...., ClassName, DatesAndTimes) VALUES (...., '::ClassName::', '::DatesAndTimes::')
Curtis
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
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
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
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
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.
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
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
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
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