Btw, if you ever do any VB programming, there IS a LIKE operator there that works like it does in SQL (except the "anything" wildcard character is an asterisk instead of a percent sign). The new ASP.NET, which is much more VB-like, has this!
Are you sure the string is making it intact from the sending form? In other words, if you put in a response.write at the beginning of the receiving asp,
Response.write Request.form("Message")
do you do see the entire string there, not cut off?
'Cause if you do, and you strip out...
The browser guru in my areas says if the Back button is visible, there is no way to disable it, and no way to modify the history object that it uses. I had a similar problem recently. On the page that processess the form I set a cookie indicating the form had already been submitted. On the...
OK, I didn't read your problem carefully, sorry. Ignore all my stuff about fixing on the client side! Your problem is when you are calling the cdo Send method. I think LINK9's suggestion was on the right track, but you need to replace the quotes with SOMETHING ELSE. Either strip them out...
Have you tried replacing all the quotes to PAIRS of quotes. I may be mixing up vb and html, but I think html will recognize a pair of quotes as "embedded" within the outer quotes and won't terminate your string. You will have to do this on the CLIENT side, before submitting the form...
Excellent! Much cleaner than mine. One minor correction to yours... In SqlServer at least, you cannot have the Count(*) in the Where clause. It would need to be this...
SELECT Mem_Id FROM tblnm WHERE Categories in ('b','c','d')
GROUP BY Mem_Id HAVING count(*)=3
Sorry Rexolio, we've gotten...
SELECT * FROM members m WHERE
EXISTS (SELECT 0 FROM mems_cats mc
WHERE m.mem_id = mc.mem_id AND
mc.category = 'b') AND
EXISTS (SELECT 0 FROM mems_cats mc
WHERE m.mem_id = mc.mem_id AND
mc.category = 'c') AND
EXISTS (SELECT 0 FROM mems_cats mc
WHERE m.mem_id =...
There is no built-in function that returns the number of occurrences of a given string ("LIKE") within another string (your SQL statement). What are you really trying to do, just determine whether or not "LIKE" occurs 2 or more times, or are you really doing more than that...
Your web hosting company won't appreciate you using the timing loop, because it grabs 100% of the CPU while it is running. Try the code below instead. (The response.writes are just to prove the script is working; take these out of your final code):
response.write "Start... " &...
Thanks Royred! Philosophy aside, you win the prize for simplicity. Your solution does not (1) hog the cpu, (2) require an external vbs script, or (3) require a database connection. I was concerned I might annoy my Server Support people with message boxes while they were logged on to the IIS...
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.