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 Mike Lewis 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: *

  • Users: Gnana
  • Order by date
  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