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!

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

Recent content by Gnana

  1. Gnana

    Extension has only two lines

    One of the extensions is showing only line 1 and line 2 and intercom, intercom and Handsfree. Line 3, 4, 5 and 6 are assigned to Line Pool A. How can I change it to line 3, etc. We have Modular ICS 6.1 with Callpilot 100 If I bring the extesion phone and connect it to mine, it works fine as...
  2. Gnana

    Variable instead of Where clause

    This worked. Thank you so much. I had been struggling with this for two days - trying so many different syntax possibilities.
  3. Gnana

    Variable instead of Where clause

    If I hardcode the field name [Clinical] into the query, it works fine. Please see code: THIS CODE WORKS FINE - BUT FIELD NAME HARDCODED Temp = "SELECT * FROM [Members for Web] WHERE [Last Name] like '" + _ StrQuoteReplace(LastName) + _ "' AND [Preferred Given] like '" +...
  4. Gnana

    Variable instead of Where clause

    The following line gives me an error (missing operator) Temp1 = "[Clinical]='" & [Clinical Psychology] & "'" ************************** THE FOLLOWING CODE IS WORKING BUT DOES NOT PULL ANY RECORDS Temp1 = '"Clinical Psychology" Temp2 = "[Clinical]" The query will be: Temp = "SELECT *...
  5. Gnana

    Variable instead of Where clause

    Here is the code to find the client choice: AreaList = Request.QueryString("lstArea") select Case AreaList Case ClinicalPsychology Temp1 = "Clinical Psychology" Case CounsellingPsychology Temp1 = "Counselling Psychology" Case else Temp1 = "Health Psychology" end select
  6. Gnana

    Variable instead of Where clause

    Thank you for responding so quickly. I had to rush home early yesterday. The problem I have is that for what I am doing, I need to change the WHERE clause depending on what the client chose from the list. If they chose "Clinical Psychology", I need the WHERE clause to be: [Clinical] = '1234'...
  7. Gnana

    Variable instead of Where clause

    This is an Access table on an IIS Website. When someone chooses from a list, I have to change the Where clause. The sql statement I tried is: Temp = "SELECT * FROM [Members for Web] WHERE [Last Name] like '" + _ StrQuoteReplace(LastName) + _ "' AND [Preferred Given] like '" +...
  8. Gnana

    Variable instead of Where clause

    Can someone please help me. Can a WHERE clause be put into a variable. I need to change the WHERE clause based on a slection user makes on the website. For example, can I do something like this: Dim Temp Temp = [Clinical] = '1234' [Clinical] here is a field name from a table.
  9. Gnana

    PowerEdge 2500: Adding two hard drives

    Thank you. I contacted Dell and they told me to download and run a hard disk diagnostic tool. A small program running on DOS. It showed that one of the hard drives was bad. Dell had sent me a replacement the next day. Everything seems to be fine now. As per your advice, I have...
  10. Gnana

    PowerEdge 2500: Adding two hard drives

    Thank you for your reply. I eventually figured it out and created a separate container with RAID 1 and initialized these two drives and I was able to see them inside Netware. I even assigned a portion of it to a volume. The next day, a signal light flashed indicating problem with those two...
  11. Gnana

    PowerEdge 2500: Adding two hard drives

    Can some one please tell me the process or where I can find the information. I have a PowerEdge 2500 with two hard drives (9GB each) setup with RAID 1 mirror. I want to add two more new ones (36GB each. The PowerEdge has RAID controller. I am running Netware 6.
  12. Gnana

    Automated Attendant should not first ring at reception

    Can someone help me please. We have a Norstar Voice Mail 4.0 with Norstar ICS Modular 8X32. I have setup an Automated Attendant with CCR Tree. I have set it up to ring twice before AA answer - in order to pick up the caller id. Problem: When someone calls, it rings the operator/receptionist...

Part and Inventory Search

Back
Top