Reply Not More 40 Hrs

Here is the answer...not letting overlap scheduling per person for the same day.Code:

rs8.CursorLocation = 3
rs8.open "SELECT ID,sch_route,sch_time_start,sch_time_end,sch_date FROM realschedule " &_
"WHERE sch_date = #"&rsDate&"# " &_
"And driver_id = "&rs("Driver_ID")&" " &_

"AND ( ((#"&st&"# between sch_time_start AND sch_time_end) " &_
"or (#"&et&"# between sch_time_start AND sch_time_end) )" &_

"OR ( (sch_time_start between #"&st&"# AND #"&et&"#) " &_
"or (sch_time_end between #"&st&"# AND #"&et&"#) ) )",conn

View Replies


ADVERTISEMENT

Reply To Newsgroup

how can I reply to newsgroup for quicker response

View Replies View Related

Reply-to Address

can someone tell me if it's possible to send delivery status notifications (or NDRs) to the Reply-To address (specified in CDOSYS script) rather than the FROM address?

View Replies View Related

Reply Interested

Problem fixed
^.^

Using ADODB.Command and call stored procedure

It can pass unicode data

You cannot call the stored procedure by using following method

set rs = server.createobject("ADODB.Recordset")
rs.execute "stored_procedure 'param1', 'param2'", connection

This method is sql collation dependency, and cannot stored other coding for example: if you want said simplify chinese in database, which collation is Taiwan, it is failed although you set the field as N'' type.
^.^

View Replies View Related

Sent Messages/reply To User Error

I have a problem when a user login to the site and when they tried to write or reply a message to other user I got this error message:

Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/write.asp, line 122

800401f3


I am running windows 2003 server with IIS6 installed with all the access component install. I am not sure what causing it. The weird part it sent or reply messages to the user but it just give that error messages. I had include the error code below write.asp I only copy and paste half the text in here. Code:

View Replies View Related

Parent - Child - Submit - Reply

I am trying to redirect back to a child form after a submit with a file upload and verification of file data. I would like to go back to the form and display a message returning the status of the data. Is that possible? Any suggestions on an alternate? I am using classic ASP, javascript and vbscript.

View Replies View Related

ASP Formmail W/ Courtesy Reply Back?

Can anyone help me with asp code for my form that enables sending a confirmation/courtesy e-mail back to the form submitter?

View Replies View Related

ASP-Based Webmail: Include Original Reply Formatting

I'm building an ASP-based CRM system; a user sees the original
message, posted from the database and can hit a Reply button to
generate a TEXTAREA field on the next page that houses the original
messages and allows them to type a reply and hit a "Send" button.

The original message from the database includes natural line breaks,
as submitted--it doesn't contain any HTML breaks.

I would like to accomplish two things:

1) Add a "> " before each line of the original message, as contained
in the reply

2) In conjunction with the "> " preceding each line, break the
original messge string into logical line lengths that fit inside the
textarea field and don't wrap.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved