Search results for query: *

DeZiner, If you view from one time and playing around with those cfquery, you will see a cleaner record rather than in the database side. From this approach, you can save your trouble matching inside the loop and this will slow down the performance where it requires more time to do the...

If that is the case, you can store these two tables into one table which has a flag or a boolean to indicate whether it's processed or not. record card amount processStatus 1 1234 5 n 2 3456 6 y 3 1234 5 n Or you can ve other...

You can create a custom tag for this. If there are too many htm files that you need to create. <!--- A file that calls the custom tag ---> <cfset FilePath = &quot;c:\temp\myoutputfile.htm&quot;> <cfmodule name=&quot;static&quot; url=&quot;generateHtm.cfm&quot; destination=#FilePath#>...

What i can suggest you is .... after the process of saving the edited data, you can call the javascript or provide a button to close the pop up window ... over here you can include the close window javascript as well as the refresh at the parent window (screen a) <script...

:) Actually, i didn't notice that comma was put on your second sql query to update the sysUserID table, that's my mistake, i'm sorry. I'm glad you managed to get your solutions! Cheers! I'll be having holiday next week. I ll be back after next week. Don't worry, i won't run away ... i'll be in...

Josel, Looking at your codes, most probably you are updating two tables. It could be the relationship of the tables that you defined. Two tables are &quot;sysAccount Table&quot; and &quot;sysUserID Table&quot;, if both tables as the relationship, you must carefully do your update statments...

Hi, Josel. Yes, it would be another problem if the data type in the table is text instead of a valid date type. I suggest you set this field as the date type so that you don't ve any trouble saving the 'date value' into your table. CreateOBDCDate() function is to return a date in ODBC date...

Instead of remove the quotes or not, i suggest you use CreateODBCDate() function for your date at LastUpdated field. Example: <cfset todaydt = #DateFormat(now(), &quot;DDD, MMM D, YYYY&quot;) LastUpdated = #CreateODBCDate(todaydt)# it's a best practise to do the formatting in a local...

Instead of remove the quotes or not, i suggest you use CreateODBCDate() function for your date at LastUpdated field. Example: <cfset todaydt = #DateFormat(now(), &quot;DDD, MMM D, YYYY&quot;) LastUpdated = #CreateODBCDate(todaydt)# it's a best practise to do the formatting in a local...

You can view the default session expiry time at the cf server. By default it is set to 20 mins, but this doesn't mean the user has 20 minutest to access the site, it means user can not idle for 20 minutes. sshhz

First of all, if you wish to upload some files to the server, you can consider two tag to use either cffile upload or cfftp. cffile has more advantage and could be dangerous to use as this is a restricted tag in cf server. while cfftp is used when you have some environments like different user...

When you create a structure or an array or combination of both and session that, you can bring to any form as long as the session is not timed out. Looking at the codes give above, i suggest you use structure and array to construct your shopping cart easily. Some simply on these: <!--- define...

Can you try to use Evaluate() function on the form fields? Example: <cfif Evaluate(&quot;Form.pic1&quot;) is &quot;&quot;> <!--- do nothing ---> <cfelse> do your uploading </cfif> You can do it in a loop, so that it's more need and tidy. Good Luck. sshhz

Actually, when you define a unique application name in the application.cfm, it won't conflict with other applications. Since you this application.cfm in every subfolders, it is very safe to use same session name variables among these subfolders and main folders, with the condition that...

You can try to use cfftp, which the web server must provide a ftp user account to access the directories. Other than that, you might consider other scripting language like javascript. sshhz