I've taken over the development of a web app written in ASP. It's not
very well coded. In the live environment it's fine, but on my local
machine it falls over whenever it tries to pass a date to a SQL Server
sproc. No idea why the person before me's been doing all this string
formatting with his dates, but anyway, the error is:
Application uses a value of the wrong type for the current operation.
The dates throughout are in mmddyyyy format, and presumably ADO
running on my local machine wants ddmmyyyy. I'm rebuilding the whole
app in C#.Net anyway so I don't think it's worth me running through
and making this jumble of code international date friendly, so my
question is, where exactly is the date format for ADO defined?
Windows? SQL Server?
SQL "Select * FROM kmCarbonlessCost WHERE Part = "'" & CCSpecificProduct & "'"" rs1.Open SQL,cn,1,2 IF NOT rs1.EOF THEN xCarbonlessCost=trim(rs1("CostAfterRebates")) ELSE xCarbonlessCost=0 END IF rs1.CLose
I have no idea what I'm doing wrong.
Error msg: Microsoft VBScript runtime error '800a000d'
I have a ASP and SQL Server website which uses a couple of Stored Procedures during the Shopping Cart process. 1 inserts the Customer information into a table and the next inserts the Payment information into a table.
I don't have access to the code now, but have found that many of our customers, especially those who use I.E 6 are having problems with a
" -2146824867 Application uses a value of the wrong type for the current operation"
error message which occurs when the Stored Procedure is executed.
I have looked through the Google archive but can't find anything specific about this message. Could anyone tell me if there is a known issue with IE6 and Datatypes with Stored Procedures, and if so how to resolve it?
i am trying to grab 2 integer values from a mysql db and get their percentage....in asp...what is wrong with the above statement, b/c i get this error:
ADODB.Recordset error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
ADODB.Recordset (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
I'm trying to populate a form based on records determined by the selection made from a drop down box. The drop down is populated fine, but the same methods seems unable to work for the rest of the form and I receive the above error message.
I have a search form that searches through employee records by either employee number or last name. I have 2 radio buttons, one for last name and the other for employee number. The value of those radio buttons tells the query what to search by. My problems is if they forget to select last name and type text into the search field. I get an error of course. How should I handle this? I need some fresh eys on the problem.
If request.QueryString("action") = "search" AND request.form("searchby") = "nam" then rsTraining.Source = "SELECT * FROM EMPLOYEE WHERE " & searchby & " LIKE '" & criteria & "%' AND STATUS ='Active' ORDER BY NAME_LAST, NAME_FIRST" End If
If request.QueryString("action") = "search" AND request.form("searchby") = "num" then rsTraining.Source = "SELECT * FROM EMPLOYEE WHERE " & searchby & " = " & criteria & " AND STATUS ='Active' ORDER BY NAME_LAST, NAME_FIRST" End If
I have created a login page for my website but I am trying to add some code to the page so that once a user has voted they can't keep on voting. Code: ...........
In the existing code is a recordset created with a function with the property forward-only. The behaviour of the result has to be changed. If there is one record found then an action has to be taken place. So I created a new recordset with the goal to count the records. Code:
Iam using a filter in asp and it doesn't work with the wildcard '_' or even using IN it only works with LIKE '% (anydata) %'. In my table i have a column, which stores values as 1,23,40 etc. How do i get it to bring back all rows where X='1' and not X LIke '%1%'
I get the following error message:
'Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.'
I need to create an ADO Parameter object with the "Numeric" type. How do I go about this?
I thot that I'd be able to follow the pattern of creating ADO parameters with the more "regular" types (Varchar, Integer, etc..) but apparently, there's some conflict somewhere between my ASP line that calls ADO's CreateParameter method, the ADO Command's Execute method, and the SQLServer Stored Procedure's parameter declarations. Code:
I'm trying to connect a dbase but an error appear. This is the error type:
"ADODB.Recordset(0x800A0BB9) arguments are of the wrong type are out of acceptable range or are in conflict"
I used the code for example:
rs.Open "SELECT * FROM table1", db, adOpenStatic, adLockPessimistic
The microsoft ASP documentation says that adOpenStatic, adLockPessimistic, equals to 3,3 notation. I used first the code above then the error appears. But when I change it to 3,3 it runs ok.
I got a problem while running an application. The code for this is as follows:
aList = Split(strMsg,";") For nX = 0 to UBound(aList) strarry=split(aList(nX),"_") var_year=left(strarry(2),4) var_month=mid(strarry(2),5,2) var_day=mid(strarry(2),7,2) var_date=var_day&"-"&var_month&"-"&var_year var_time1=mid(strarry(2),9,2) var_time2=mid(strarry(2),11,2) var_time=var_time1&":"&var_time2 set rs1=conn.execute("insert into tbl_BackupfileInfo(Filename,Createddate,Createdtim e)values('" &aList(nX)&"','"&var_date&"','"&var_time&"')") Next
while runnig this application some times it works fine .But some times it giving an error
Error Type:Microsoft VBScript runtime (0x800A000D) Type mismatch: 'UBound'.
if left(session("lastPage"), 5) <> "admin" then session("return") = session("lastPage") else session("return") = "" end if
My problem is even the "left(session("lastPage"), 5) is equal to "admin" it still not equal the variable session("return") to "". Can anyone please tell me why or what Im doing wrong?
I'm Trying this code to switch the user group , so this code select users with groups only if the user doesn't have a group or does'nt exist redirect it to another page Her is my code please check it Code:
sql="select * from users,groups where users.user_id='"&id2&"' and users.group_id=groups.g_group_id" set rs=conn.Execute(sql) if rs.eof or rs("group_id")=null then Response.Redirect("switch.asp?id="&session("session_id")&"&page=management") else dim group group=rs("group_id")
end if and It gives me this error message Error Type: (0x80020009) Exception occurred.
I have web prgramming to check login. After first time login, I still could login even type wrong password and username, but I need correct login when trying different computer. Is the problem with cache?
The output contains only one record it is supposed output 2.. sch_date in db are 10-Oct-07 and 14-Oct-07 ....
Code:
rs.Open "SELECT * FROM schedule WHERE trim(sch_date) between #"&FormatDateTime(trim(x),2)&"# and #"&FormatDateTime(trim(y),2)&"# ",conn response.Write(rs.recordcount) response.End()
Microsoft VBScript compilation (0x800A0409) Unterminated string constant
Here is my Query, It is slight incorrect:
newest_sql = "SELECT TOP 5 CatID, ContentID, DateAdded, Title, FeaturedLabel, NewestLabel FROM Content, ContentTypes Where Content.ContentTypeID = ContentTypes.ContentTypeID AND (((Content.Display)=1) AND ((ContentTypes.ContentTypeId)=4)) ORDER BY DateAdded DESC"
I am not sure if this is in the right thread, but...I am making my new website and I haven't been able to get a 'siteinclude' file to work with my default page. I created a site wide file, basically, includeing the header and table of contents and eventually the footer. I have other sites like this, but cannot figure out what is wrong with this one. I thought that by putting together a site wide file, i could easily generate many pages that are similar, by adding <!--#include virtual="/siteinclude.asp"--> to the top of the page. Then making the page regularly, save it as .asp and it should have when I just created as well as the 'siteinclude' info, right? Well, the problem I am having is with the default file. It is appearing BELOW the 'siteinclude' info, instead of within it.
Is there anything wrong with my code (see below) bcoz when 10p-6a shift my browser returns the error cannot be a zero-length string. Im wondering why, bcoz the 2 other shift works perfectly.
<% 'Shift: 6a-2p if DatePart("h", Now()) 5 And DatePart("h", Now()) < 14 then ShiftID = "A" end if
'Shift: 2p-10p if DatePart("h", Now()) 13 And DatePart("h", Now()) < 22 then ShiftID = "B" end if
'Shift: 10p-6a if DatePart("h", Now()) 21 And DatePart("h", Now()) < 6 then ShiftID = "C" end if %>
sql="select * from [tblbuy] where Location like '" & request("location") & "' "
The above code is working fine. Now i wondering in case the request "location" value is: * is it possible to modify my sql statement that will retrieve ALL when the value is * (an asterisk)?
In one of my setup, the server REMOTE_ADDR(url = Request.ServerVariables("REMOTE_ADDR")) does not work, itgives a IP address but the wrong one. It does not give the IPaddress of the machine surfing the page. It seems to me that itis giving me the IP of some proxy server. Is there a work around to this issue ?
I am using access with sch_time_start,end,start_time,end as text fields not as Date/time....I am getting wrong amount of record...Example:
If db has 6 records like start_time and end_time = 12:00 AM- 05:15 AM, and person has sch_time_start and sch_time_end = 12:15 AM-05:12 AM.....I am missing smth...maybe logic is wrong.. Code:
I'm developing a web page which displays the link popularity of a site from various search engines using xmlhttp. Yahoo, MSN, etc all work fine, but I'm having problems with Altavista and Excite returing the wrong results.
For instance, if I want to find the link popularity of URL from Altavista I would use xmlhttp on this URL:
URL
and it produces 1,412,312 results. But when I go to that same URL in my browser it shows 1,339,554 results. Can anyone shed any light on why this is happening?
