Solved

Question Continued from previous class registration question

Posted on 2004-08-10
14
178 Views
Last Modified: 2013-12-24
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
0
Comment
Question by:dtolo
  • 9
  • 5
14 Comments
 
LVL 12

Expert Comment

by:rcmb
Comment Utility
This is actually a message from the FrontPage Database Results Wizard (DBRW). What happens is the database simply does an insert so no records get returned from a query.

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
0
 
LVL 2

Author Comment

by:dtolo
Comment Utility
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



0
 
LVL 12

Accepted Solution

by:
rcmb earned 500 total points
Comment Utility
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("DaysAndTimes")%>" size="15">
<input type="hidden" name="ClassName" value="<%=request.form("ClassName")%>" size="15">

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
0
 
LVL 12

Expert Comment

by:rcmb
Comment Utility
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&DatesAndTimes=654321

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
0
 
LVL 2

Author Comment

by:dtolo
Comment Utility
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.
0
 
LVL 12

Expert Comment

by:rcmb
Comment Utility
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=<%=fp_rs("ClassName")%>&ClassDate=<%=fp_rs("ClassDate")

The field information ("<%=fp_rs("ClassName")%>") would be generated on the fly from the database.

Curtis
0
 
LVL 2

Author Comment

by:dtolo
Comment Utility
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
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 2

Author Comment

by:dtolo
Comment Utility
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
0
 
LVL 2

Author Comment

by:dtolo
Comment Utility
The server is wss not sts
0
 
LVL 2

Author Comment

by:dtolo
Comment Utility
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.
0
 
LVL 2

Author Comment

by:dtolo
Comment Utility
I think that this site might tell us how to do it http://www.oakleaf.ws/wsslistsasp/AboutListUpdates.aspx
0
 
LVL 12

Expert Comment

by:rcmb
Comment Utility
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
0
 
LVL 2

Author Comment

by:dtolo
Comment Utility
OK,

Will do.
0
 
LVL 2

Author Comment

by:dtolo
Comment Utility
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
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now