Thanks evaleah,
Yes, the varchar is the comma-delimited list that I'm passing to the stored procedure from my ASP page. I am unfamiiar with using DTS packages, which is why I'm using this method.
Some background: There are several checkboxes on a form that a user can select, all linked by IDs...
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...
Sorry about that. That typo was soley in the message to Tek-Tips. There is no typo in my actual code. [sadeyes]
The big problem here is getting my IFRAME data to pass with my form. It seems like there's no way to do this. I tried document.all.mailbody.value, but I am still unable to actually...
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="javascript">
function checkForm(){
var theform = document.frmsdnemail;
//Check for the e-mail body...
Thanks, Genimuse. That almost worked. I think I may have solved my own problem with the following:
For i = 1 to chkcount
For j = 1 to usercount
If newPrefArray(i) = dbArray(j) Then countmatch = countmatch + 1
Next
if countmatch = 0 Then 'add record
countmatch = 0 <== reset the...
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...
Thanks SQLSister,
I thought of that option before, but thought it could be too cumbersome since our user database has at least 1300 records. I assume you're saying that this shouldn't be a problem with the new table. Is there a limit on the number of records any table can have?
Thanks for all...
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...
oops. noticed a bug in my code print out. it should say this for the javascript:
JAVASCRIPT
function OpenPreviewWindow(fld){
var theform = document.frmCreate;
var thefield = theform.fld; <== Not working
var now = new Date
strMessage = escape(thefield.value);
document.cookie =...
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...
Well, someone else was able to help me out with this problem. All I needed to do was to set the body ="" after I send each email.
objNewMail.From = "support@somedomain.org"
objNewMail.To = email
'support HTML text for body
objNewMail.BodyFormat = CdoBodyFormatHtml...
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...
dilettante, Thank you for your comments, but they really didn't help much at all. Tarwin provided the best solution to my problem. I used it, and it's working fine.
dillettante, I completely understand HOW the web works and how pages are processed. The question I asked has nothing to do with...
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="docs/myfile.pdf" onClick="<%=Call LogHit("/private/reports/ama")%>"> 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, "<%=Application(""rootsite"")%>","http://www.somesite.org",1,-1,1)
But this doesn't work and I've...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.