Hi ,
You didn't mention which database server you are using. Assuming that you are using SQLServer and jid column in j table is set to default identity.
INSERT INTO j ( bBoxtotal ) VALUES ( 35 ) //inserting into j table
DECLARE @last_id int
SELECT @last_id = max(jid) FROM j //getting the last jid
INSERT INTO b ( bjobid , bBoxNumber , bBoxtotal )
VALUES ( @last_id,...
jayadevi
Last Activity: Sep 3 '07, 10:59 AM
Joined: Sep 6 '06
Location:
-
Hi Meher,
Instead of making the code complex by using Configurations , you can use following simple code,
...Code:Set cabreg=CreateObject("CDO.Message") cabreg.Subject="Denver CAB Registration" cabreg.From=inname cabreg.To=sfc@fms.treas.gov" cabreg.TextBody=Inbody cabreg.Send set cabreg=nothing Response.Write("The e-mail has been sent")Leave a comment:
-
Hi ,
Let the number of rows returned is 60.
Response.Write "There are " & rs.recordcount & " rows that were returned"
Is the above statement returning correct result,in this case 60?
If it returns correct result, then the problem is with for loop.
Instead of using for loop, u just try these below statements,
...Code:If not rs.eof then do until rs.eof
Leave a comment:
-
To get the IP address of Local machine using asp
Hi all,
I have to get IP of the local machine. For ex:Using machine A , i have connected to another server(machine) B, in machine B i am browsing one asp page which gets the IP address using the code
Request.ServerV ariables("remot e_addr")
which returns the IP of machine B.
But I want to write a asp code which gets the IP address of machine A.
If anyone knows how... -
Hi ,
Your code is working fine. Actually I copied the code from ur page and pasted in my textpad.
Inbody = "DENVER CAB REGISTRATION FORM” & vbcrlf
In the line above, instead of the second "(double quotes) near FORM, it just pasted some other character like pipeline. That time , it was showing error page 'Page cannot be displayed". Then I changed that to " , it is working fine....Leave a comment:
-
Configuring IIS for LDAP Authentication
Is it possible to configure an IIS to do both LDAP authentication and Windows authentication?
For ex: Suppose one application of server A is hosted in IIS. The requests come from two different intranet users( let it B and C). B is using windows Operating system and the IIS of server A is configured to do Windows authentication for B users. Likewise we need to make the IIS of server A to authenticate intranet C users. C is using Unix OS ,... -
Configuring IIS for LDAP Authentication
Is it possible to configure an IIS to do both LDAP authentication and Windows authentication?
For ex: Suppose one application of server A is hosted in IIS. The requests come from two different intranet users( let it B and C). B is using windows Operating system and the IIS of server A is configured to do Windows authentication for B users. Likewise we need to make the IIS of server A to authenticate intranet C users. C is using Unix OS ,...
No activity results to display
Leave a comment: