I think the query is SELECT distinct((M.MAWB_NUM)) as m_cnt FROM pull_data Where isnumeric(M.MAWB_NUM) = 1 ... ===== M.Balakumar Flat s/2, Priya Flats ...
Hi All - I noticed that the source view of my CFM generated pages was adding alot of whitespace before the first <HEAD> tag appeared. In addition to the...
Keep in mind that this is an index killer and shouldn't be used on really really large tables. -John ... From: Balakumar [mailto:bala130977@...] I think...
My personal preference and my personal suggestion is to enable CFOUTPUTONLY and then wrap everything you want to be sent to the browser inside CFOUTPUT...
The following code produces groupings by Division, with the given Division as a label for the group. However, each group contains ALL the employees, regardless...
You'll want to use the "group" attribute of cfoutput. See the example below. <cfoutput query="ThirtyYearAwards" group="Division"> #Division#<br /> <cfoutput> ...
FROEHLING, ROBERT (AIT)
rf5782@...
Mar 1, 2005 8:46 pm
31656
Thank you! It worked (as if you didn't know it would:-). You saved my day! Thanks. God bless you....
ColdFusion Hosting Providers ColdFusion Hosting Providers' List brought to you by *** ColdFusion-HowTo: Yahoo's No. 1 and the biggest group for ColdFusion...
coldfusion-howto@yaho...
Mar 2, 2005 4:23 am
31658
The people who manage my servers have switched us to an APACHE 2.0.52 server with CFMX 6.1. I had been using the code below to send people to the correct...
Sounds like your old apache was resolving out the domain names from the IP address. May want to look into that. But as a rule, don't assume that every IP...
I have a query that is going to return a string that contains CFM which references FORM varaibles, such as <cfquery datasource="#Application.dsnname#"...
Probably the easiest way to do something like this is to generate a new temp file that contains your CFMAIL tag with the data returned from the query and then...
do u know asp. then compare asp and coldfusion function . that's it and this is how i learnt coldfusion 4.5 . it took 2 weeks to completely understand and 4...
I learned ColdFusion by simply reading through the docs on the functions and tags. However, if you think you mastered ColdFusion in four months, take a look...
Hi, Did u try evaluating that expression inside the query? Your query should like <cfquery datasource="#Application.dsnname#" name="cwm_text"> SELECT...
Hi, Is any of these salted hash? My boss asks me to use salted hash, but the hash funtion only use these algorithms. I hope one of these is the algorithm I...
Hi, how can I read out from XML all XML-Attributes: <xml> <test id="1"></test> <test id="2"></test> <test id="3"></test> <test id="4"></test> I want all values...
Hello all, I am using cfttp to publish cfm pages as html. I am btw running cf 5. It publishes well but I realized something weird. Some of these cfm pages...
Hi I am having a problem in validating the user data in a form. The form generated contains data from the tables(database). I need to check if the user changes...
Hello all, Everyone's been a big help when I've been here before so I wanted to give it another try. This time I have a fairly simple question that's probably...
Hi all, I have a table filled with news articles from the past six years. I would like to build a link of years so people can browse stories from each of those...
Aarthi, You could validate the dates and check if they changed using javascript: - pass your dates (from the database) to javascript using hidden variables -...
SELECT DISTINCT YEAR(dateFld) AS yearStr FROM tbl YMMV depending on the database used. mcg _____ From: Kim Siever [mailto:kim.siever@...] Sent: Thursday,...
Well, whatever webserver they were using was resolving IP addresses to domain names - that process needs to be duplicated in the Apache environment if...
