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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sending a ColdFusion e-mail in both plain text and html
pcorreia, This looks perfect. Have you tested on CFMX, on a Linux platform, if you could be so kind as to provide the tag, I'd be happy to provide feedback with this environment. My email kevinfaulkner@hotmail.com -
Passing Select list parameters
Hi Kristine, You've actually done more coding than you need. As you have method="POST", you do not need any URL params, as the whole form is passed to the action template. So you just need to remove the reference on the URL... <cfform action="Policy_Details.cfm"... -
grabbing just the last four digits...
Hi LeadMan, if the problem you are having is that it's going to the DB truncated but is OK on the screen, then its that you are storing the 4 digits as a number/integer, which will be truncated by the db. If you store it as a char(4) field, it should retain the length. Obviously for calculations... -
cffile - limiting uploads to gif and jpg only
You could try this.... seems a bit long now, but should do the validation you want. The consequences of a user renaming...? Pass! <HTML> <HEAD> <SCRIPT language="JAVASCRIPT"> function CheckPiccy() { var fileName=document.UPLOADING.THEFILE.value.toLowerCase(); if... -
Date Searching
A blank page would indicate no rows, so if still in dev and you have access to Administrator, trying turning on "Show query information " in debugging. This will let you know whether your query is returning anything, as it may be a join prob if not. If rowcount is > 0, then your... -
to show just last four digits of credit card number?
Also, to make it look even more realistic ( ************0123), I once used <CFOUTPUT> <CFSET stars=#LEN(cardnum)# - 4> <CFLOOP from="1" to=#stars# index=loop> * </cfloop> <CFLOOP from = #loop# to=#LEN(cardnum)# index=loop2> #MID(cardnum,loop2,1)# </cfloop>... -
Word/PDF Generation
Aaah, got it! I've done some string processing to build the RTF source into a variable, use CFFILE action=write NAMECONFLICT=OVERWRITE with this variable to write file into a temp storage. Then nornal mimeattach with CFMAIL, and optional clean up by deleting file. Or is there a better way... -
Word/PDF Generation
Hi I've just found this, a bit late too though I'm afraid. Yes generating RTF's isn't too tricky, even got one including a picture of a signature. But I want to take it one step forward and upload the generated doc, and then attach it to an email, then delete the doc, all automated...any ideas? -
Upload security
Excellent, that's just what I needed, I had a feeling it would be safe anyway, but a little knowledge can be more dangerous than none, and the boss had heard the word virus and panicked!! Thanks for the CFDIRECTORY tip, like it! -
Upload security
If I validate that files must be .gif or .jpg before they are uploaded to my server using CFFILE, does that secure the upload from virus'? I had planned to do a quick javascript check, but have now found "accept=image/*", which is safer... Also, can the size of the uploaded file be... -
New database permissions
Hi, I've created a new database on SQL7 and have been able to verify connection with CF Administrator. However, any queries based on this database is returning Base Table Not Found. Now obviously I've checked spelling and everything, but when I ran a quick query via CF on the sysobjects... -
add a link to favorites
Hey Blue, Yep it is really a script thing, but if you haven't heard from another forum, try this... Adding Faves doesn't work with NS, so maybe having an alert letting your user know? <HTML> <HEAD> <SCRIPT language="JAVASCRIPT"> function Faves() { var... -
Anyone recognise "ia_archiver"
Thanks tl, Went to Alexi.com and sent them an email asking about how to get spider friendly. Cheers for the advice. K -
Anyone recognise "ia_archiver"
Hi, I have an error handler emailling me of any template errors by my users. I got a handful last week, stating "ia_archiver" as their browser... I figure this may be some kind of search robot or similar, but wondered if anyone knew more. "ia_archiver" is all it... -
Indexes for performance
Thanks for getting back to me. I did find the SQL server forum, and posted a similar question.. Got good responses and it seems that some diagnostics are what is needed ( DBCC CHECKDB with REPAIR_REBUILD if you're intested!) So you get a cigar!! Cheers, K -
Occasional Index error
That's great, thanks. Just one thing though, what exactly does the DBCC CHECKDB with REPAIR_REBUILD do to the data, as it is a live database which is accessed from both the UK and Aus, so I shan't have a quiet time to run it. So how long will it take, and is all access locked when it is...- bigKev
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Occasional Index error
Hi, I have a Cold Fusion error handler which emails me any problems, and overnight, I had a couple of these ... "[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find the index entry for RID '369a7e0020010e0504d' in index page (1:1272), index ID 0, database 'rec9'." It...- bigKev
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Indexes for performance
People, Possibly more of a SQLserver question than CF, but hope you can help anyway. I'm from a DB2 background, and trying to learn CF based on that - probably a bad start. I have a table ( c 30000 rows ), which gets hit by many different searches. Is there a limit to the amount of indexes... -
Count of active sessions
Quite simple, I have a count of users on-line in the password protected area of my site, but can I, using the session management or otherwise, display a reasonably accurate total of the number of people using the public site at any time ... eg to display "You are 1 of 1234 candidates...
