the error msg is that ur missing some CDO interface setup.
try adding the port - also i think you can leave out the username and pwd entirely rather than leave them blank:
myMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") _
=25
checkboxes arent included in the request object if they are not checked...
so :
if request("cbox") <> "" then
...
tells you that something was selected.
have you added .net to the site in IIS and chosen what framework it runs under.
other than that perhaps the extension (aspx) are not listed to be handled, check file types.
formitem=" & request("formitem") & "<br>" & -
"..."
or if ur happy to just grab the lot:
for each item in request.form
strBody = strBody & item & "=" & request.form(item)
next
stasJohn's method is very interesting - nice job.
However i would guess the sql server would have a fit executing that query !
ie. doesnt it do (in english terms)
for each row in db - patindex every column against the search string.
= manual table scan
sqlBill's answer is nice and would work...
i might be missing your point but the table has the search terms as separate columns.
wouldnt it be best to split the search term in the interface and pass thru parameters?
declare @city = null,
declare @state= null etc etc
then just use a normal where clause like
WHERE ((city = @city and...
just a tip for making show/hide functions easier also
call them with showhide(this)
then
function showhide(object this)
then you have a direct handle on the single item to show/hide rather than getting elementbyname
is that your exact code cause there's some crazy " ing going on :) :)
"UPDATE tbl_operators_users SET password="& spassword & " where oid = " & soperatorcode & " and username = " & susername
your sql syntax seems fine
well i changed it to a negative lookaround and that didnt get included in the capture - whew, itll do what i need.
(d[:|]{1}[\\\/]{1})(?!['\x22\\])
ie. has d:\ or d|\ or d:/ etc but no trailing '"\
but i tried many a type of "non capturing" regex's and .net kept getting all characters (at...
Hi - any .net regex peeps out there :)
i have this regex to update mapped drives with UNC paths
(d[:|]{1}[\\\/]{1}))(?:[^\\n]\w)
which using expresso successfully gets d:\ or d|\ back with the exception of some d:\n' newline bits here and there.
in .net when using the replace method the non...
personally i find it easier to build a setup program marked with build for com interop.
do the install and it all works noice (oh the hassles i have had with com interop...bleah)
just watch out cause IIS caches the assembly and needs a iisreset /restart to clear old versions.
Lol - it would but then i fear that Outlook would cease to function =p ie. you'd remove all callback methods from the selection change event...
Well after a day of head scratching and posting this morning - i just found my stupidity !@!
In the method which was being called from the handler i...
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.