DatePart Wrong Code
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
%>
View Replies
ADVERTISEMENT
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.
View Replies
View Related
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.
View Replies
View Related
Is it possible to pass a variable containing the full date and time to 'DatePart'? I want to grab just the time of day portion of a date. As in: Code:
<%
dim submit_date
submit_date = Now()
submit_time = DatePart("h","n","s", submit_date)
%>
View Replies
View Related
Does anyone know how to use the DatePart function?
View Replies
View Related
i am trying to use the DatePart function on my SQL2000 database. I have a table called visitors with a field called DateTimeEntrance which is filled everytime a visitor enters the site. I am trying to build a stat page where i display the total amount of visitors per day, week, month, year and i can't seem to get the syntax correct.
I get an error with the following code:
sql = "SELECT * FROM tblVisitors WHERE (DatePart("yyyy",
[datetimeentrance])) = (DatePart("yyyy", date()))"
can anyone help me with the correct syntax?
View Replies
View Related
I'm trying to increment between the end of lunch and the end of the day. The code below is returning a datePart of 13 instead of 1 (for 1:00:00 PM) and 14 instead of 2:00:00 PM etc. If response.write just counter2 I get a real hour. how can I return the actual hour datePart?
lunchStart = "12:00:00 PM"
lunchEnd = "1:00:00 PM"
dayEnd = "5:00:00 PM"
counter2 = cdate(lunchEnd)
while counter2 >= cdate(lunchEnd) AND counter2 <= cdate(dayEnd)
response.write datePart("h",counter2)
counter2 = dateAdd("h",1,counter2)
wend
View Replies
View Related
i used formatdatetime(dt,vblongdate).it gives me in format like monday , august 8th, 2005.but i dont want weekday means monday or tuesday in my date so on.
<%
prior = Request("Date")
if isDate(prior) Then prior = CDate(prior) Else prior = #1/1/1900#
For dt = DateAdd("m",-1,Date()) To Date-1
%>
<OPTION value="<%=dt%>" <%If dt = prior Then response.write "SELECTED" %>><%=FormatDateTime(dt, vbLongDate)%> </option>
<%
Next
%>
</SELECT></center> </td>
</tr>
View Replies
View Related
I'm trying to use DatePart and Datediff functions to show the formatted m/dd/yyyy display for the dates of Monday and Friday of the current week. I want it to display as:
Our Weekly Schedule 8/23/2004 thru 8/27/2004:
Can't pinpoint the parameter to check for the current week. Is there a good reference anywhere to show how to use the methods and such of both datepart and datediff, or has anyone programmed something similar prior.
View Replies
View Related
I'm using the following code on my website:
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?
View Replies
View Related
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?
View Replies
View Related
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()
View Replies
View Related
I am getting the error message
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"
View Replies
View Related
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?
View Replies
View Related
I have the following SQL in my ASP:
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)?
View Replies
View Related
Why do i keep getting the following error?
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/_script/main.asp, line 22
I have a simple script that has always worked!
Code:
View Replies
View Related
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 ?
View Replies
View Related
I'm getting the following error:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another. Code:
View Replies
View Related
I got the following error:
ADODB.Command error '800a0d5d'
Application uses a value of the wrong type for the current operation.
/Include/Authors.asp, line 71
Line 71 is the one with sphone: Code:
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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'
Type mismatch
/FunctionUpdate.asp, line 74
View Replies
View Related
I am trying to put a URL into the body of an email message but I can't get it to display as a link. Code:
View Replies
View Related
i have a form value which accepts the date format in the dd/mm/yyyy Code:
View Replies
View Related
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?
View Replies
View Related
I'm trying to query an Access database with an asp page hit with a hidden form from an ecommerce site. It was working fine until I added a new variable ("speed"), and now I get the following error: Code:
View Replies
View Related
I use the Stream method to serve certain file types to the user. If the
type is pdf, it opens in the browser fine. My problem is with those
that the browser doesn't have plug-ins such as ppt, word, etc. it
prompts to choose Open/Save/Cancel and defaults the filename to the ASP
page serving the content. ie. BinarySend.asp -> BinarySend.doc,
BinarySend.ppt.
If I use
Response.AddHeader "content-disposition", "attachment;filename=" &
sFileName then it defaults the filename to the name I specify but
always prompt a download instead of opening directly.
Is there another way to default the filename in situation like this?
View Replies
View Related
I've got the directory f:CompanyProduct set as web shared so it's got a
virtual directory in the default web site on my test server's IIS. If I try
to use Server.MapPath in that site it returns a path within
c:Inetpubwwwroot rather than the real path.
Can anyone please tell me why this isn't working?
View Replies
View Related
I'm running win 2000, I downloaded a calender and put it into my root website folder. the calendar folder contained a file called adovbs.inc . After the insertion of this folder and creating links to it we noticed that when the web page loaded it's home page, another older page that has been deleted is displayed.
This page was located in the calendar folder. So now I've deleted the calendar folder, and restarted the server but this old page is still on display.
View Replies
View Related
perct = Math.round((cInt(objRS4("total"))/cInt(objRS5("ttl")))*100,4)
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.
View Replies
View Related
The interval that a driver is available from 5:00:00 AM to 8:00:00 PM....
And I dont want to pick this route that runs from 10:15:00 to PM 4:00:00 AM...because the driver is not available btw those times..However my query picks that tooo..Why? Code:
View Replies
View Related
i get the following error every time, what's wrong?
Error Type:
ADODB.Command (0x800A0D5D)
Application uses a value of the wrong type for the current operation.
/dwprojects/newday/Step1.asp, line 33
Here's my code:
View Replies
View Related
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.
View Replies
View Related