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!
-
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: sshhz
- Order by date
-
Two tables, break inside loop.
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... -
Two tables, break inside loop.
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... -
generate a html file
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 = "c:\temp\myoutputfile.htm"> <cfmodule name="static" url="generateHtm.cfm" destination=#FilePath#>... -
Parent Window Refresh
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... -
ODBC Error Code 37000 ... Please help, I'm going crazy with this!!!
:) 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... -
ODBC Error Code 37000 ... Please help, I'm going crazy with this!!!
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 "sysAccount Table" and "sysUserID Table", if both tables as the relationship, you must carefully do your update statments... -
ODBC Error Code 37000 ... Please help, I'm going crazy with this!!!
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... -
ODBC Error Code 37000 ... Please help, I'm going crazy with this!!!
Instead of remove the quotes or not, i suggest you use CreateODBCDate() function for your date at LastUpdated field. Example: <cfset todaydt = #DateFormat(now(), "DDD, MMM D, YYYY") LastUpdated = #CreateODBCDate(todaydt)# it's a best practise to do the formatting in a local... -
ODBC Error Code 37000 ... Please help, I'm going crazy with this!!!
Instead of remove the quotes or not, i suggest you use CreateODBCDate() function for your date at LastUpdated field. Example: <cfset todaydt = #DateFormat(now(), "DDD, MMM D, YYYY") LastUpdated = #CreateODBCDate(todaydt)# it's a best practise to do the formatting in a local... -
sessions timing out way too early!
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 -
How to restrict file types in cffile upload
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... -
StructInsert order problem
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... -
cffile multiple upload problem
Can you try to use Evaluate() function on the form fields? Example: <cfif Evaluate("Form.pic1") is ""> <!--- 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 -
how to properly lock session variables when locking by name
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... -
Uploading Files to web
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
