This is how you update a row in SQL using ASP. strq = "UPDATE crs_applicants SET education_completed = " & education_completed & ", graduate = " & graduate & "" strq = strq & " WHERE tdb_id=" & tdb_id & ";" cnnConn.Execute strq SHARETHIS.addEntry({...

This shows you how to delete a row in sql using asp. strq = "DELETE FROM general_census WHERE db_id = " & db_id & ";" cnnSimple.Execute strq SHARETHIS.addEntry({ title: "Delete command in sql using asp", url: "http://code.netexceed.com/asp/delete-command-in-sql-using-asp/"...

Here is how to order by ASC or DESC in sql. Use ASC for ascending and DESC for Descending. Set objGetSort1ENTCensus = cnnConn.Execute("SELECT * FROM qxSQLCensusBasicView ORDER BY occupancy DESC") SHARETHIS.addEntry({ title: "ORDER command in SQL using ASP", url: "http://code.netexceed.com/asp/order-command-in-sql-using-asp/"...

Using the len variable we can check the database to make sure something exists. if Len(objSendEmail("file_name")) > 0 then objMailJ1.AttachFile strFile end if SHARETHIS.addEntry({ title: "Using LEN in asp", url: "http://code.netexceed.com/asp/using-len-in-asp/" });

Shows you how to change the display name in an email sent from asp. objMailJ1.From= "Jason Mohan <jasonmohan@nospam.com>" objMailJ1.To= "" & email_address & "" objMailJ1.Subject="New Code:: Activation Link" objMailJ1.BodyFormat=0 objMailJ1.MailFormat=0 objMailJ1.Body=html objMailJ1.Send SHARETHIS.addEntry({...

Shows you how to read the date fields in SQL or Access files through ASP. SELECT * FROM main_ca WHERE date_submit BETWEEN #MMdatefrom# AND #MMdateto# ORDER BY id_stamp DESC SHARETHIS.addEntry({ title: "Reading dates into SQL from ASP", url: "http://code.netexceed.com/asp/reading-dates-into-sql-from-asp/"...

This allows you to remove spaces in asp. variablename = TRIM(objGetAPP("resume_name")) SHARETHIS.addEntry({ title: "Using TRIM in asp", url: "http://code.netexceed.com/asp/using-trim-in-asp/" });

This code shows you how to embed a rss feed into a webpage. You can also download the below code  rss_feeds_into_webpage.txt. <% Response.Expires = -1 ' =========== RSS2HTML.ASP for ASP/ASP.NET ========== ' copyright 2005-2007 (c) www.Bytescout.com ' version 1.23, 14 June 2007 '...