Search results for query: *

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

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...

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...

Hmmm Is it even possible? Regards, Kabbi

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 ! --->...

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

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...

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...

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...

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=""...

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...

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

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

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...

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...

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...

thank you for your answer!

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...

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

Thank you!