Viewing 15 posts - 181 through 195 (of 217 total)
Govinn,
Thank you for your reply. However, this won't work, because there is no relation between the clientmaster and dmvrequest table.
Now you may ask, then why am I doing this. I'm...
August 10, 2005 at 9:05 am
Forgive my ignorance, but how do I tell the stored procedure what variable goes where? Right now, I just my variables defined...
August 8, 2005 at 8:05 am
I don't think I can do this in ASP, because I'd have to pass the variables like so:
'all the variables from all the forms
SchoolName = SchoolName
SchoolCounty = SchoolCounty
SchoolType=SchoolType
etc....
set dataConn = Server.CreateObject("ADODB.Connection")
dataConn.Open ...
August 8, 2005 at 7:42 am
Remi,
Oh yeah, thanks.
BTW...why would I do all the inserts in the stored procedure?
My issue with this is, how the heck would I...
August 8, 2005 at 7:26 am
Thank you for all your help guys,
When creating the stored procedure, won't I need to do something like:
create procedure prc_modulename_insertbig (
@SchoolName varchar(50),
@SchoolCounty varchar(50),
@SchoolType char(1),
@SchoolAdd1 varchar(100),
@SchoolAdd2 varchar(100),
@SchoolPhone char(11),
@SchoolFax char(11),
@SchoolIP ...
August 8, 2005 at 7:10 am
Sushila,
1) The five inserts you have to do!
I have to insert data from 5 forms into 5 different tables. So one of the inserts would look like this:
INSERT INTO School(UniqueId,...
August 5, 2005 at 2:14 pm
Even if I do somehow manage to write the stored procedure, how do I handle to uniqueid? How do I link all the tables together?
August 5, 2005 at 1:56 pm
Thank yous
Ok , I can do an insert, and I can put together an error check, but how would I handle the UniqueId that servers as the key to link...
August 5, 2005 at 1:51 pm
It sounds beautiful...but also extremely difficult. I wouldn't even know where to start!
August 5, 2005 at 1:41 pm
DSP, I agree with you on the first step; I will do the INSERT on the last page.
As far as table structure goes, I have 5 tables: School, Students, Professors,...
August 5, 2005 at 1:13 pm
I think I got it working:
strSQL="SELECT SQ.*, DEdescription, DEenteredDate
, ST.AOcontactNameLast AS SendTo
, BT.AOcontactNameLast AS BillTo
, R.AOcontactNameLast AS Requestor
, DE.*" &_
FROM schoolrequest SQ" &_
LEFT JOIN academicoffice ST ON SQ.SLsendToId=ST.AOid
LEFT JOIN academicoffice...
June 22, 2005 at 8:20 am
I'm still going for it...although I'm thinking of splitting the one query into two. So the first one would be:
SELECT SQ.*
, ST.AOcontactNameLast AS SendTo
, BT.AOcontactNameLast AS BillTo
, R.AOcontactNameLast AS Requestor
,...
June 21, 2005 at 11:36 am
SLFine,
I think my biggest issue now is that I felt as if I was getting somewhere(with Remi's invaluable guidance) with the original query, but now I'm totally lost as what...
June 21, 2005 at 10:20 am
The form is just one form though. It has maybe 15 total fields and pulls information from three tables. I don't understand what is wrong with that. All the data...
June 21, 2005 at 9:13 am
Viewing 15 posts - 181 through 195 (of 217 total)