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

  • 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

    Hi, First make two tabels, In the example I made: csv_naam (headers csv file) zdev_naam (headers/fields table) offset readvar Put the right data in this table like for instance: header csv header table offset rv SystemInformation_SerialNumber...
  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#)

    Hi, Thank you all! I used the following now: <cfif IsDefined ("FORM.value") AND #FORM.value# NEQ ""> <cfset lijstlengte= #ListLen(FORM.FORM.value)#> <cfif IsDefined("lijstlengte") AND #lijstlengte# NEQ 0> <cfset nieuwkopvar = ListQualify(FORM.value,"'",",","ALL")> <cfquery name=""...
  11. gadjodilo77

    WHERE VALUENAME IN (#FORMVALUE#)

    Hello, I have a question.Imagine I have the following FORMvalue or Formvariable: BER-06-3005,BER-06-3008,BER-06-3008 What I want to do is to make a query using this formvalue. Each BER-06-xxxx number is a namenumber in an database table. What I want to do is make a Query and select the data...
  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...

    Hi, With a little help I am able to insert a csv file into a database table. Now I have to insert some values of this table into another table. The problem is that I also have to insert some other data into the other table. For instance in the CSV table I have a column called PC_volgnr There...
  17. gadjodilo77

    advanced delete query sql

    thank you for your answer!
  18. gadjodilo77

    csv file upload problem

    Hi, I have a code wich uploads a csv file into a database table. It works fine if all the fields of the csv file are filled. However when there are a few empty fields it is not going good. As you can see have I used this code: <CFSET content=replace(content,";;;",";x;x;","ALL") > <CFSET...
  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