Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ShorePatrol

    How do I do this??? Query/Design Question

    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!
  2. ShorePatrol

    How do I do this??? Query/Design Question

    There we go! Thanks!!!
  3. ShorePatrol

    How do I do this??? Query/Design Question

    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)....
  4. ShorePatrol

    How do I do this??? Query/Design Question

    It has 1/2 hour increments....
  5. ShorePatrol

    How do I do this??? Query/Design Question

    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...
  6. ShorePatrol

    How do I do this??? Query/Design Question

    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...
  7. ShorePatrol

    How do I do this??? Query/Design Question

    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...
  8. ShorePatrol

    How do I do this??? Query/Design Question

    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 =...
  9. ShorePatrol

    Simple Script Needed

    Very cool - thanks!!!
  10. ShorePatrol

    Simple Script Needed

    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...
  11. ShorePatrol

    Simple Script Needed

    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...
  12. ShorePatrol

    AutoAnswer with Direct Connect?

    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?
  13. ShorePatrol

    AutoAnswer with Direct Connect?

    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...
  14. ShorePatrol

    AutoAnswer with Direct Connect?

    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...
  15. ShorePatrol

    Automated TEXT Capture?

    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...
  16. ShorePatrol

    AutoAnswer with Direct Connect?

    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...
  17. ShorePatrol

    Automated TEXT Capture?

    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...
  18. ShorePatrol

    Automated TEXT Capture?

    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...

Part and Inventory Search

Back
Top