There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot bsod computer connection cpu crash css dell desktop dma driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware hijackthis hjt install internet internet explorer itunes keyboard laptop macro malware monitor motherboard network networking outlook outlook 2003 outlook 2007 outlook express pio problem problems router seo server slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp winxp wireless
Web Design & Development
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Internet & Networking > Web Design & Development >
Web Application - SQL and VB Script


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
dbimen's Avatar
Senior Member with 118 posts.
 
Join Date: Jul 2006
26-Oct-2007, 09:17 PM #1
Web Application - SQL and VB Script
The two sets of code for the problem can be downloaded here....

www.newhostsite.com/amhsParents2/code


I know it needs to be cleaned up a little but, I need to get this to work first!

I am trying to have the user select the person's name on the first page and on the second page, display available time slots for an appointment.

I am not getting any response on the 2nd page when the names are selected on the first page.

The table of the people listed is tblTeachers. The table with the appointments is tblParentTeacher.

tblTeachers has a column called Item_ID which is the primary key in addition to a column called TeacherName. tblParentTeacher has numerous columns but also includes TeacherName as a column.

When the name is selected, the available appointments should show up on the 2nd page. Right now, I am getting no data, but no error. This means to me, that I am just making a mistake with the code.

The name that is selected on the first page should be the value in the TeacherName column of the record that is displayed from the tblParentTeacher table.

I hope I explained it clearly so that you are able to see if you can find the problem.

Any help is much appreciated...Let me know
dbimen's Avatar
Senior Member with 118 posts.
 
Join Date: Jul 2006
27-Oct-2007, 04:34 PM #2
bump
haswalt's Avatar
Computer Specs
Senior Member with 416 posts.
 
Join Date: Nov 2004
Location: South Coast, UK
Experience: Advanced
29-Oct-2007, 08:13 AM #3
well clearly you are not getting the teacher id correctly first. I get that error when i try it.

I select a teacher name so it passes the name of the teacher to the asp script but without seeing the code i can't help more.

We need more information before we can say more.
__________________
LQD Internet Limited
We've just got better! With the launch of our new site we have SLASHED our prices and upped the offering. Check it out!

10% Discount for ALL Tech Support Guy Members
Simply use the promo code of "T3CHGUY" when ordering to recieve your 10% discount on all shared and reseller hosting packages.
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 02:01 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.