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 derfloh 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: gadjodilo77
  • Order by date
  1. gadjodilo77

    Compare dates.....

    Hi, Thank you very much for your answer. It works! Regards, Kabbi
  2. gadjodilo77

    Compare dates.....

    I also keep getting this error if I try to compare it and show the differences per month. "06" is not a valid date/time format. The following list contains all valid datepart masks: yyyy - Year q - Quarter m - Month d - Day w - Weekday ww - Week h - Hour n - Minute s - Second...
  3. gadjodilo77

    Compare dates.....

    Hi, I have a question. I have to get information out of a Novell database using LDAP. One thing is the "LastRegisteredTime" all that is possibble and it give the dat like this: 20060507072033Z To us e this date I had to rearrange it a little bit... So it ends up like this: 2006-05-07...
  4. gadjodilo77

    update sql database with data from ldap database

    Hmmm Is it even possible? Regards, Kabbi
  5. gadjodilo77

    update sql database with data from ldap database

    Hi, I have to update a SQL database table with some LDAP data from a novell database. Here is how I planned to do it: <cfquery name="devZen" datasource=""> SELECT dev_id, dev_serie, dev_typenr FROM dev WHERE dev_typenr = '1' </cfquery> <cfloop query= "devZen"> <!--- Connectie ! --->...
  6. gadjodilo77

    popup selects input form

    Hi, I now used some javascript, which works fine. function sendValue(s){ var selvalue = s.options[s.selectedIndex].value; window.opener.document.form1.mail.value = selvalue; window.close(); } Thank you anyway! Grt, Kabbi
  7. gadjodilo77

    popup selects input form

    Hi, I wonder. I have a form with a couple of input formfields. Is it possible to let users select the data to be inserted/filled in in the formfield by openening a pop-up screen which shows data from a query. If people select an item, than this item will be placed into the formfield...
  8. gadjodilo77

    Import Excel File into SQL Server

    ...from="1" TO=#listlen(element,";")#> <CFSET Input=ListGetAt(Element, offset, ";")> <CFQUERY NAME="getconversie" DATASOURCE=""> Select * FROM zen_1 Where offset=#offset# </CFQUERY> <CFIF getconversie.recordcount> <CFIF len(trim(getconversie.csv_naam)) NEQ len(trim(input))>...
  9. gadjodilo77

    Problem inserting/formatting &quot;date&quot; values

    Hello, I have made a script that uploads a csv file into a database table. De data is directly inserted in a temporary table. The second step is then after uploading it in the temporary table to insert the data into another table. However I have a date field in the other table and the date...
  10. gadjodilo77

    WHERE VALUENAME IN (#FORMVALUE#)

    ...AND #lijstlengte# NEQ 0> <cfset nieuwkopvar = ListQualify(FORM.value,"'",",","ALL")> <cfquery name="" datasource=""> SELECT * FROM devices WHERE dev_volgnr IN (#preserveSingleQuotes(nieuwkopvar)#) </cfquery> But I'm curious if this will work also: <cfqueryparam cfsqltype="varchar"...
  11. gadjodilo77

    WHERE VALUENAME IN (#FORMVALUE#)

    ...I tried several things but I don't know how to do it. I tried it like this: <cfquery name="name" datasource="source"> SELECT * FROM dev WHERE dev_volgnr IN (#FORMvalue#) </cfquery> This gives the following error however: Error Executing Database Query. Column not found: Unknown column...
  12. gadjodilo77

    inserting multiple rows (from a loop..)

    Yes, thank you. I already figured it out... did not expect it to be easy like that. Grt
  13. gadjodilo77

    inserting multiple rows (from a loop..)

    Hi, Thank you. But how would I repeat this for each row?
  14. gadjodilo77

    inserting multiple rows (from a loop..)

    If you see the following thread: http://www.tek-tips.com/viewthread.cfm?qid=1187823&page=1 You see at the bottom the results. They are being showed in a loop: <cfoutput>#myString# / #typenumber# / #codenumber#</cfoutput><br> How can I insert these loop results into another database table? row...
  15. gadjodilo77

    a difficult one... get values for all data instead of one variable...

    Someone explained me a little. Here is the solution, if you might have the same problem: <cfif q.recordcount GT 0><!--- anders niks zien ---> <cfset temp = ValueList(q.PC_volgnr)> <CFLOOP INDEX="Teller" FROM=1 TO=#ListLen(temp)#> <cfset myString = ListGetAt(temp,Teller)> <!--- of...
  16. gadjodilo77

    a difficult one... get values for all data instead of one variable...

    ...that device so I can put those values also in a field in the new table. Currently I have it like this: <cfquery name="list" datasource=""> SELECT * FROM inventimport WHERE PC_volgnr NOT IN (SELECT dev_volgnr FROM dev) Order by inv_id </cfquery> <cfset temp = ValueList(list.PC_volgnr)>...
  17. gadjodilo77

    advanced delete query sql

    thank you for your answer!
  18. gadjodilo77

    csv file upload problem

    ...from="1" TO=#listlen(element,";")#> <CFSET Input=ListGetAt(Element, offset, ";")> <CFQUERY NAME="getconversie" DATASOURCE="rug"> Select * FROM importconversie_1 Where offset=#offset# </CFQUERY> <CFIF getconversie.recordcount> <CFIF len(trim(getconversie.psnaam)) NEQ...
  19. gadjodilo77

    advanced delete query sql

    Hi, If I understand, this means that the formfields cannot be made dynamically. The formfields have to be made in advance doing it this way isn't it? Grt, Kabbi
  20. gadjodilo77

    advanced delete query sql

    Thank you!

Part and Inventory Search

Back
Top