I have an SQL query within an ASP statement that is not parsing correctly for some very strange reason. When I try and parse the statement, it coms up with the error, 'Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.'
I have successfully run the query within MS Access. The SQL query that I ran in Access is below: Code:
i got a problem dealing with this sql statement, i data stored in a table in 3/13/2006 format, and i input this data into table by calling date() using asp, but when i try to run an sql statement by using this sql statement,
a="2006/3/5" b="2006/3/7"
sql="select * from userlog where AccessTime between '"&a&"' and '"&b&"'" response.write sql set rt = conn.execute(sql)
if rt.eof then response.write "no record" else response.write "got record" end if
i got no record display on my page, may i know what to do to get the data from the tabel?do i need to change the structure when i insert this date or do i need to change the structure of my variable a and b in order to perform this search correctly?
"Select * from table1 where dDate = #" & CStr(Date()) & "#"
this query executes well on one computer where the date format is - "MM/DD/YYYY" but fails on the other computer - which has a date format of "MM.DD.YYYY".
if i write the query like this on my second computer -
"Select * from table1 where dDate = #" & Replace(CStr(Date()),".","/") & "#"
SELECT * FROM biblewheel_url INNER JOIN bible ON biblewheel_url.letter_id = bible.book_spoke WHERE ( text_data like '%number%' OR text_data like '%day%' OR text_data like '%forty%' OR text_data like '%year%' ) AND bible.book_spoke = '4' Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
In Access you use "*" + [passed variable] + "*", + can be replaced with & Calling a parameterized query in Access requires % be used in place of *, however, all that I have read show dynamic SQL passed to Access:
WHERE [some column] LIKE '" & ASPvar & "' % ORDER BY ...
However, my call is similar to:
conn.qMyLookup strVar, rs
If I modify the query in Access to:
"%" & [passed variable] & "%"
I get all records. If I only put it at the end, as suggested, I only get matches at the end, not throughout the column. Code:
I was wondering what would be the best function to format a name. Say I have a function FormatName that takes in a string that is FRED SMITH and needs to return Fred Smith. The function basically needs to make sure the first character of each word is capitalized. What is the best way to do this?
how do you format an email in asp. For example: i want my email to read, The following customer has requested two tables then on the next line, it should provide customer's name then next line address and on and on. Quote: Originally Posted by nschafer Or if you want a button instead of a link:
I must have the format of the below line wrong for IE:
click <a href="cal.asp?sdate=<% =strDate1 %>&location=<% =strLocation %>&eTime=<% =strDate2 %>">here</a> to add this information to your Calendar<br>
When I hover my mouse over the link, the status bar at the bottom of the page for IE says: shortcut to 2006 11:00 AM With Firefox I get: http://sd-school/forms/cal.asp?sdate=10/18/2006 10:00 AM&location=Library&eTime=10/18/2006 11:00 AM
The form works in Firefox, which is what I use for testing. So either the format is wrong, or IE doesn't like the spaces or something. It doesn't matter which dates I use, I get the same results.
At the moment I'm entering a new record in my database for every pageview (the record holds several things like IP, useragent..etc). I think this is asking too much of my database, and I get a lot of errors all the time. Perhaps I should switch to entering each 'record' into a XML-file, and use that for my statistics? Any disadvantages, performance issues?
i am encountering some problems in converting some data into CSV format..i have alreadi retrieve the data however i do not knoe of ani methods of converting to CSV...is there ani method to save the directory to .csv
I have a problem don't know how to write the attachment file frm mail....
<html> <head> <title>Thank you for reply with us.</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <%@ Language=VBScript %> <% Dim strBody Dim myElement
For Each myElement in Request.Form Select Case Left(myElement ,3) Case "txt","sel","rad": strBody = strBody & Replace(Mid(myElement,4,len(myElement)),"."," ") & _ ": " if Len(Request.Form(myElement)) = 0 then strBody = strBody & "UNANSWERED" else strBody = strBody & Request.Form(myElement) end if
strBody = strBody & vbCrLf
Case "chk": strBody = strBody & Replace(Mid(myElement,4,len(myElement)),"."," ") & _ ": " & Request.Form(myElement) & vbCrLf Case "are": strBody = strBody & Replace(Mid(myElement,4,len(myElement)),"."," ") & _ ": " & Request.Form(myElement) & vbCrLf End Select Next
strBody = strBody & vbCrLf & strFooter
'Time to send the email 'Dim smtp Set smtp = server.CreateObject("CDONTS.NewMail")
'****************************************** ' set the mail properties '****************************************** smtp.Subject = "ApplicationForm" smtp.From = "ApplicationForm" smtp.To = "connie@auroraxsis.com" smtp.Body = strBody
'****************************************** ' fire off the email message '****************************************** smtp.Send 'Response.Redirect "thankyou.asp"
'****************************************** ' check return value error code '****************************************** 'if objMail.errorCode = mmeNone then ' Response.Redirect "thankyou.htm" 'else ' Response.Write ("Mail message was not delevered to the SMTP server." & "<br><br>") ' Response.Write ("Please try again later" & "<br><br>" ) ' Response.Write ("The error code was :" & Cstr(objMail.ErrorCode) & "<br><br>" ) ' Response.Redirect "" 'end if
'****************************************** ' always destroy the object '****************************************** ' set smtp = Nothing
' Response.Write ("Thank you for advertising with us. We will revert to you soonest possible.")
' Response.Redirect strRedirectURL %> </HTML>
<script language="JavaScript"> <!-- //set message: msg = "Welcome To International Education Counsultancy"; timeID = 10; stcnt = 16; wmsg = new Array(33); wmsg[0]=msg; blnk = " "; for (i=1; i<32; i++) { b = blnk.substring(0,i); wmsg[i]=""; for (j=0; j<msg.length; j++) wmsg[i]=wmsg[i]+msg.charAt(j)+b; }
function wiper() { if (stcnt > -1) str = wmsg[stcnt]; else str = wmsg[0]; if (stcnt-- < -40) stcnt=31; status = str; clearTimeout(timeID); timeID = setTimeout("wiper()",100); }
I use an ASP mail object to send orders filled online to a recipient via an e-mail. I would like to know if it's possible to format the way the order looks in an e-mail? I tried the following, but see no change in the format:
Does anyone know if it's possible to format the way the text look in an e-mail that is sent using the ASP Mail Object? Is there a different way of controlling the format/appearance of the text that appears in an e-mail?
I've looked over the last 2000 posts for info on incorportating an RSS feed on a web page using ASP to control the display - especially which elements are shown and how many items are shown. I found a free ASP script that I hoped would do the job >>>
I've had some excellent help before on this forum and hoping for some more. This is probably very basicbut I'm kind of muddling along a bit and it's a miracle I got so far.I have a memo text field in a table form and I'm wanting to enter text into it but all a small amount of formatting. Just basic paragraph breaks would be a start. This is kind of following on from a previous post of mine where I was trying to include line breaks. This was the solution.
I have some pictures in database.now i am printing it using response.write in one page.It is working properly.I want to print it in such away(it should follows google page)like every page it should print 2 and then another page.
In one of my asp webpage,i am fetching the data from a XML file and which indeed is fetching data from mySql database.
Now the date time format i am getting in from XML is "Wednesday, October 24, 2007, 2:03:42 PM" and when i display that time in my asp webpage then it shows like "Wed, 24 Oct 2007 19:03:42 +0000"
I'm currently building a form and I'm attempting to take the date and convert it into the same format as an unformatted date in Excel. I believe it's called SAS. Is there any way to format a date into this format using excel?