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 Chriss Miller 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. WhiteHatMarine

    SX-200 ICP fowarding during voicemail when pressing 0

    If there is any more information I could provide to help diagnosing this issue, please let me know.
  2. WhiteHatMarine

    SX-200 ICP fowarding during voicemail when pressing 0

    Hello, I am told this function was working then seemed to stop. User calls in and gets VM Press 0 routes to Ext 201 and receives, "currently on the phone message" If I dial direct to ext 201 internally or externally, no problem. From Call Rerouting Table - 19: Station Dial 0 routing...
  3. WhiteHatMarine

    Query help

    In between replies I have been trying many, many things and changing things quickly, working to find a acceptable solution. Definitely not twiddling my thumbs waiting for replies Olaf. Since I do recognize various SQL dialects, testing in access does have its benefits for me in this situation...
  4. WhiteHatMarine

    Query help

    First and foremost, I am here with eyes wide open. I do believe I am not doubting the help. I am grateful. I simply failed to remove [] from my post. This is mostly because I was testing the query in MSaccess linked to DBF's and the [] are supported. As many people do I edited my code to...
  5. WhiteHatMarine

    Query help

    Mike: I did read your post well, thank you. I was not sure how to utilize the cursor, perhaps it would work in Cold Fusion as well, I just did not expand on that idea. The brackets came over from e semi-functioning version of this query in MSAccess. I believe in Access and VFP ODBC, brackets...
  6. WhiteHatMarine

    Query help

    I updated using Borislavs example, fixed few small errors but still getting a syntax error. SELECT a.item , a.ionhand , b.lonhand , b.orderpt , b.lonordr , getQuery1.MatAllocated , getQuery1.MinReqDate FROM icitem10 a INNER JOIN iciloc10 b ON a.item = b.item INNER JOIN (SELECT...
  7. WhiteHatMarine

    Query help

    Thanks guys, here is more information I should have provided initially. Query1 & Query2 are names I just placed in this post for easier reading, they cannot be referenced by the query as coded now. This query was working in MSaccess with linked tables but issues with full outer join and...
  8. WhiteHatMarine

    Query help

    I have a tricky query I cannot seem to come up with a good solution for. The first query functions. Second needs works. I would like to make this a single query, need help with that. The WHERE statement in Query2, not sure how to handle this as well. Query2 should be the result set. Code...
  9. WhiteHatMarine

    missing comma error with IIF and LIKE

    Turns out LIKE() only supports * and ? and NOT # for digits. At least in my environment which is Cold Fusion and FoxPro ODBC Driver. Any suggestion for testing for digits? item = 30400M01 IIF(LIKE('#####M##*', item),PADR('yes',3),PADR('no',3) ) AS myResult myResult from this is "no", as you...
  10. WhiteHatMarine

    missing comma error with IIF and LIKE

    All the input is a huge help, thanks again. This is my first time dealing with FoxPro. So the final problem Im dealing with is using the field alias's ( myGroup myDiv myProdType ) in the evaluation and result expression of the IIF. I was able to get around the evaluation portion by just using...
  11. WhiteHatMarine

    missing comma error with IIF and LIKE

    Thanks all, this has been a HUGE help. It is so close to totally working now. On my last IIF if the test is false I would like to set myDept AS [myGroup] [myDiv] [myProdType] but get an error: Function name is missing Is this a VFP function limitation or syntax issue? Any thoughts on getting...
  12. WhiteHatMarine

    missing comma error with IIF and LIKE

    ok, thanks thats a huge help to know. So I have it working now with this statment: ,IIF( (SUBSTR(aa.item, 1, 1) = '7') = 1, 'Homo', 'Not Homo') AS TEST Is there a better way to do a string comparison? I need something similair to the LIKE operators , #, ? , * etc.. For instance I need...
  13. WhiteHatMarine

    missing comma error with IIF and LIKE

    cannot seem to isolate this one...if I change the LIKE to = it works. Error: Missing comma SELECT aa.wono ,IIf(aa.item LIKE '7*' ,'Homeopathic','not homo') AS TEST FROM (((ppwohd10 aa INNER JOIN (icitem10 bb LEFT JOIN tblProductTypes dd ON bb.itmclss = dd.ItemCode) ON aa.item = bb.item)...

Part and Inventory Search

Back
Top