Search results for query: *

Hi, I am having trouble with the use of syntax in my ASP code. It is truncating the Title at the first blank space. The code when it is not involved in a response.write is as follows: <a href="javascript:ViewDetails('Project_details.asp?Title=<% = rs("Title") %>');" class="FormField">View</a>...

HI! I am loading distinct Names from a field in a Contractors table to populate a drop down menu, which when you make a choice it will ultimately populate the contractors field in the Projects table. The drop down menu is being populated fine, But when I choose an option and press submit it is...

Hi, I am trying to use a CDOSys email script that is failing at the .send line. I am used to using ASP Email so I am not familiar with the quirks that come with CDOSys. Here is the script I am using... <% Const cdoSendUsingMethod = _...

I am trying to query my DB with this statement: <% set connection = server.createobject("ADODB.Connection") connection.open session("DBConnString") Start = Date() This_Month = DateAdd("d", 30, Date()) SQL = "select * from Events Where Start_Date Between Start AND This_Month" set rs =...

Hi, I'm not sure how to call a VB function from a form. I want to generate a random number when a button in a form is clicked. This is what I have so far... The Function: <% Dim MyValue Function Randomize upperlimit = 5000000.0 lowerlimit = -300000.0 MyValue =Int((upperlimit -...

I am trying to populate dropdown options in a form so the user can make the selection and when they hit submit the jobs the contractor is involved with will show in another section of the page. I have 13 records in the database. As of now it is populating the options with one record 13 times. I...

I am gettin an error "No value given for one or more required parameters" when using a select case structure to query the database based on the first letter in the title. I could have sworn it was working fine yesterday. Can someone tell me if this is sytactically correct? case "S" sql =...

I am trying to write a script that will validate one field in a form (Title). It can not be left blank and it can only be alphanumeric. I am using a javasript at the moment. It has worked before but now if I leave the title field blank it just ignores it. I am also trying to implement a script...

I am trying to use an asp upload function. I am basing the image upload on the ID in the RS. ID = upload.form("ID") Title = replace(trim(Upload.form("Title")),"'","''") EventDate = Upload.form("EventDate") Description = replace(trim(Upload.form("Description")),"'","''")...

Hi, I am using an asp script to upload images and I am using the ID as the image name. I am using the same code on another site and it functions fine...I am stuck with this one. Here it is... Set Upload = Server.CreateObject("Persits.Upload") Upload.Save ("C:\Temp") Set File =...

I've always been confused when writing sql withing the ASP syntax parameters. Can someone help me with this statement? choice = request("choice") P_Status = request("P_Status) sql = "select * from Projects " sql = sql & "where ( title like & choice ) & " sql = sql & "and (P_Status =...