Search results for query: *

Yes, I will use an array.... I won't have any events that span across days, so that keep it a bit more simple. Thanks for your suggestions! it should help a lot!

There we go! Thanks!!!

Let me give a better example: Let's say I have data in an EVENTS table as follows: EVENT_ID = 233 START_DATE = '8/21/05 8:00:00 AM' END_DATE = '8/21/05 1:00:00 PM' ROOM_ID = 5 How would I query to see if ROOM #5 was taken at 10 AM (Which in this case, it would be)....

It has 1/2 hour increments....

Ok -you understand it, but I need the code to do it, The code is what my question is. No one seems to be able to give an example of how to detect within an event time, like my example above is asking.... Again...if there is an event in the database like this: EVENT_ID = 63 SDATE = 8/21/05...

You guys are missing my question....using your example: If Not IsNull(rs("appt")) or rs("appt")<>"" then color = 'red' end if I would have to do that for each time slot (ie. from 8 to 8:30, 8:30 to 9, etc) - which mean 48 queries in one page. I'm not sure that's the best way....perhaps 1...

Ok, but then how do I query it - if I have a table, and each row = a half hour increment, how do I turn the rows colors based on the events? i.e.: If there is an appointment that is at 9 AM, turn the table row red If there is an appointment that SPANS the 9am hour (like from 8-11), turn the...

I am creating a database that will keep track of scheduling.... So I need to store a START date/time stamp, and an END date/time stamp... For example, if someone makes an appointment from 9 to 10 AM on 8/21/05, I'm assuming the database values should be: SDATE = 8/21/05 9:00 AM EDATE =...

Very cool - thanks!!!

Wow - THANK YOU...It works wonderfully! Could you possibly walk me through &quot;peudocode-like&quot; what your script is doing? I see your capturing to a temp file, then copying it to the real file....why is this necessary (just curious)... I guess I just don't understand Procomms Script...

Hi All, I need a fairly easy script, but I don't have &quot;any&quot; aspect scripting experience...please help!!! I am currently monitoring a modem's data with Procomm (Latest Version)...the modem receives a few numbers and a # sign every once in a while (ex. 42212#) Here's what I need the...

I removed that file, and restarted procomm...no matter what I do I cannot seem to get that Hayes modem to show up in the Procomm config box, where you're supposed to select your modem.... Any idea?

Yes, it shows up as Hayes 9600....but under the &quot;Attached to&quot; column, it says &quot;not functional&quot; I'm assuming because its a serial connection? It weird because the modem DOES work....for instance if I type ATV1, I get the modem response profile/settings...etc... But I'll try...

Yes, it says direct connect - com 1 My only other choices are: direct connect - none direct connect - com1 direct connect - com2 direct connect - com3 direct connect - com4 That's the problem - I don't have an internal modem, so it doesn't &quot;see&quot; a modem....my external modem is on...

Thanks for that info Knob, Yeah, even without the script, I'm not able to see any data coming through... I need to confirm the correct data is coming from the sending computer.... I have a few concerns with my direct-connect setup (see seperate post)...but, hopefully I can hash this out...

I have an external modem, connected with a serial cable, using Procomm...I can give the modem commands successfully, Like ATA, ATZ, etc...so the modem works But all the &quot;Incoming Call Handling&quot; options are grayed out in Procomm. According to the support web site, it is because my...

Thanks for that reply....I just got Procomm installed... Another question: when the data comes to the modem, and I see RING, RING, RING...I type ATA which connects the call. Then it says: CONNECT 9600 But then it just sits there...is there a terminal command to &quot;grab&quot; any of the data...

Hi All, I'm really new to Procomm Scripting...I'm an Active Server Page (ASP) and Visual Basic programmer, but I need to write a script for Procomm.... Here's what I need it to do... We have a modem hooked up to a PBX (telephone) system. Every once in a while the modem is sent some data, not...