Asp

This shows you how to upload a file using asp. Note you will need the aspupload component from Persists software. Take the object from a form Now save it from the form. This is the file name it was saved as SHARETHIS.addEntry({ title: "Upload a file using...

Do loop in asp...

This is an example of a do look in asp. Do While Not (objAppID.EOF) objAppID.MoveNext Loop SHARETHIS.addEntry({ title: "Do loop in asp", url: "http://code.netexceed.com/asp/do-loop-in-asp/" });

Send an attachment in a...

This shows you how to send a attachment via email using asp. strFile = "c:\dir\file.vcs" Set oNewMail = Server.CreateObject("CDONTS.NewMail") oNewMail.From = "fuscptc@eximc.nam.dow.com" oNewMail.To = "u369373@eximc.nam.dow.com" oNewMail.Subject = "Updated Education &...

Sending html based emai...

This shows you how to send a html email using asp. Set objMailJ1 = CreateObject("CDONTS.NewMail") html = " ” html = html & “ ” html = html & “ Intranet ” html = html & “ ” objMailJ1.From=”intranet@no-spam.com” objMailJ1.To=”sender@no-spam.com” objMailJ1.Subject=”Subject...

Insert a row into sql u...

This shows you how to insert a row in sql using asp. strq1 = "INSERT INTO crs_job_listing (job_title, job_category, job_description) VALUES " strq = strq1 & "('" & job_title & "','" & job_category & "','" & job_description & "')" cnnConn.Execute...

Truncate the length of ...

Allows you to truncate the length of a variable in asp especially when displaying. SHARETHIS.addEntry({ title: "Truncate the length of a variable in asp", url: "http://code.netexceed.com/asp/truncate-the-length-of-a-variable-in-asp/" });

Move a row from one tab...

This code will show you how to move a row from one table to another using ASP. This involves delete and insert into. strq = "INSERT INTO archive SELECT * FROM user_requests WHERE db_id =" & objGetForm("db_id") & ";" strq1 = "DELETE FROM user_requests WHERE db_id =" &...

Replace tag using asp...

This will allow you to replace a letter or whatever with something else. Use it in reverse when pulling stuff out of a database. job_description = replace(job_description,"'","^") SHARETHIS.addEntry({ title: "Replace tag using asp", url: "http://code.netexceed.com/asp/replace-tag-using-asp/"...

Select statement with s...

How to read a table in SQL using ASP. Set objGetForm = cnnConn.Execute("SELECT * FROM crs_applicants") SHARETHIS.addEntry({ title: "Select statement with sql using asp", url: "http://code.netexceed.com/asp/select-statement-with-sql-using-asp/" });

How to connect to a sql...

This shows you how you can connect to a sql database using asp. It’s better to put this code in a seperate file and use a include statement. Set cnnConn = Server.CreateObject("ADODB.Connection") FilePath="DRIVER={SQL Server};SERVER=*****;UID=*****;PWD=*****;DATABASE=database_name" cnnConn.open...

search through our tags

Blogroll

Archives