Search results for query: *

Hi! I'm having a problem checking for the existence of a record in a table when the input is a comma-delimited list. In the stored procedure below, I need to first check to see if a record exists in the database with the group and tool id's. If not, I want to add the new record. But...

Hi There, I have a complicated ASP/vbscript/javascript page with an IFRAME in it that doesn't seem to be submitting with the form. Here is a portion of the code: <SCRIPT LANGUAGE=&quot;javascript&quot;> function checkForm(){ var theform = document.frmsdnemail; //Check for the e-mail body...

Hi, I'm trying to iterate through two arrays. The 1st array contains values from the database. The 2nd array contains values from a form. I want to hold the 1st array constant while checking values from the 2nd array against it. If the item in the 2nd array is not found in the 1st array, then i...

Hi! I'm trying to set up subscription information for a mailing list that i'm creating. A user can decide from up to 10 choices of the types of e-mail they'd like to receive. My question is how should I represent this in SQL Server 2000? I have a user table with information about the user and...

Hello, I'm trying to create a reusable Javascript function (used with ASP) that will take in a textarea and set a cook with the value of that textarea. my function works fine if i dont pass any parameters, but when i try to pass in the name of the form field, it doesn't work. I believe my...

Hi, I'm trying to send out an indefinite number of emails using ASP/vbscript and CDONTS. I am able to receive all of the intended emails, but I notice that the actual message seems to be queueing, so that I receive all of the email text combined, in the last message sent. For example, if I send...

Hi, I'm trying to make an entry into a logfile whenever a user tries to download a PDF from my site. This is the code that I have right now (which is, of course, not working): <A HREF=&quot;docs/myfile.pdf&quot; onClick=&quot;<%=Call LogHit(&quot;/private/reports/ama&quot;)%>&quot;> View...

Hi, I'm trying to excute a vbscript Replace function to produce a printable version of an ASP page. Here's what I have: strLine = Replace(strLine, &quot;<%=Application(&quot;&quot;rootsite&quot;&quot;)%>&quot;,&quot;http://www.somesite.org&quot;,1,-1,1) But this doesn't work and I've...

Hello, I've had SEVERAL problems creating successful ADO connections with ASP and SQL Server 2000. I have an ASP connection file that has the following information (connection string altered for security): <% 'Connection.asp Dim objconn, ConnTemp 'opens the connection to the db Function...

Hi, I'm having MAJOR problems expiring my cookies. When a user logs on to our site cookies are created like below: response.cookies(&quot;htc&quot;)(&quot;UID&quot;)=4 response.cookies(&quot;htc&quot;).expires = DateAdd(&quot;h&quot;,4,Now()) When the user tries to log out BEFORE the 4 hours...

Hello, I am trying to replace all occurrences of &quot;<%=Application(&quot;HtcRootSite&quot;)%>&quot; with &quot;/staging&quot; for a particular file. This is the code I tried using (Vbscript/ASP): str is a string reference to a file using an application variable. str = Replace(str...

Hello, Here's the scenario: I have a table with 11 yes/no fields that are used to hold meeting attendance for a particular month of the year. I would like a total &quot;YES&quot; count for EACH of these fields, and I want to show the results in a Report. I've tried several queries, but I'm...

Hello, I'm trying to provide a database search using pattern matching. For instance, a user wants to search for all occurences of the word &quot;access&quot; in my database. I'm having trouble writing the SQL portion of this code. This is what I have now: SrcTxt =...