Viewing 15 posts - 151 through 165 (of 217 total)
I am doing it this way...is there a better(faster) way of doing it?
strSchoolDate=Request.Form("school_date")
strSchoolDate=Trim(strSchoolDate)
...for each line.
August 19, 2005 at 11:17 am
Wow, this script is getting long with all those Trim() statements!
Anyway...I'm now getting a different error:
Error 500: Internal Server Error
August 19, 2005 at 11:08 am
so....
Set MyParam = SERVER.CREATEOBJECT ("ADODB.Parameter")
MyParam.Name = "@SRcomments"
MyParam.Value=NullFunction(strSpecComments)
MyParam.Size = 150
MyParam.Direction = adParamInput
MyParam.Type = adVarChar
and the function would be like what you have above?
Function SetVars(SRvalue)
if SRvalue = "" Then
MyParam.Value = null
else
MyParam.Value = SRvalue
end...
August 19, 2005 at 9:46 am
I don't see how I can insert a null with the code you provided...I don't see how it would fit into the structure/flow of the code.
August 19, 2005 at 9:36 am
How can I account for nulls with a script like this?
Can I use trim() to trim the stuff from request.form?
August 19, 2005 at 9:28 am
Thanks Remi, I will try that.
BTW, does the code look right? At least from glancing at it?
August 19, 2005 at 9:22 am
Hi guys! It's me again....stop cringing!
I completed the script...but it's still giving me a "page cannot be displayed" error. I've checked all the...
August 19, 2005 at 9:10 am
Hi Remi....
I spent the weekend trying to get the big insert asp page to work, but it keeps giving me a 'page cannot be displayed' error when I hit 'submit'...
August 16, 2005 at 8:08 am
Sushila, thanks, that is what I meant. I do copy & paste all time!
August 16, 2005 at 8:06 am
Remi,
No complaining, just trying to understand. I've been looking on MSDN, and other sites, but I can't find a explanation on how to pass a bunch of parameters like what...
August 12, 2005 at 12:54 pm
Can't I just pass it like you would a function?
Like
MyCmd.CreateParameter(SRrequestDate, SRschoolNameFirst, SRschoolNameLast, SRschoolCompany, SRschoolBranch, SRschoolAddress1, SRschoolAddress2, SRschoolCity, SRschoolState, SRschoolZip, SRschoolPhone, SRschoolFax, SRschoolEmail, SRschoolRegion, SRschoolSupervisor, SRschoolclaimType, SRschoolDateOfLoss, SRschoolInsured, SRschoolClaimNumber, SRschoolPackaging, SRschoolContactPrefs, ...
August 12, 2005 at 12:43 pm
If I can write this out just once, then why did Remi write it out for each and every variable? There must be a method to his madess
August 12, 2005 at 12:38 pm
Remi,
How come I just can't do this once?
<%
Dim MyCn
Set MyCn = Server.CreateObject("ADODB.Connection")
Set MyCmd = Server.CreateObject("ADODB.Command")
MyCn.Open = "DSN=OSUNet;UID=xxxx;PWD=xxxxxxxx"
Set MyCMd.ActivateConnection = MyCn
MyCmd.CommandType = adCmdStoredProc
MyCmd.CommandText = "dbo.sp_biginsert"
MyCmd.Execute
%>
August 12, 2005 at 12:31 pm
Remi,
wait now I'm confused. What would take me days to rewrite??
Thanks,
M
August 12, 2005 at 12:11 pm
Ok, all those lines now look like this:
Set MyParam = SERVER.CREATEOBJECT ("ADODB.Command")
MyParam.Name = "@SRschoolNameFirst"
MyParam.Value = SRschoolNameFirst
MyParam.Size = 150
MyParam.Direction = adParamInput
MyParam.Type = adVarChar
August 12, 2005 at 12:09 pm
Viewing 15 posts - 151 through 165 (of 217 total)