problem with ajax on cflayout form submission
Hi everybody have this cflayout name=tabtest type=tab cflayoutarea name=tab1 title=Data SJ source=tab1.cfm /cflayoutarea cflayoutarea name=tab2 title=Dati Personali source=personshowTab2.cfm !--- cfinclude template=personshowTab2.cfm --- /cflayoutarea cflayoutarea name=tab3 title=Storia in SJ cfinclude template=personshowTab3.cfm /cflayoutarea ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem with ajax on cflayout form submission
Yes steve sorry my question here is on the cflayoutarea2 tab 2 is a form that submits on an action page after it executes it goes back to the calling form from the tab but doesn't show the the updated form.. just blank even if I use the javascript below after the action query script type=text/javascript ColdFusion.Layout.hideTab('tabtest', 'tab2'); ColdFusion.Layout.showTab('tabtest', 'tab2'); ColdFusion.Layout.selectTab('tabtest', 'tab2'); /script Alex, Did you intend to include more here? Not seeing a question First peek, there's no closing cflayout tag, your 3rd tab should use the 'source' attribute, like your others, for consistency, and it appears that your code formatting is way off. Something like: cflayout name=tabtest type=tab cflayoutarea name=tab1 title=Data SJ source=tab1.cfm/cflayoutarea cflayoutarea name=tab2 title=Dati Personali source=personshowTab2.cfm/cflayoutarea cflayoutarea name=tab3 title=Storia in SJ source=personshowTab3.cfm/cflayoutarea /cflayout Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub. com/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 9/6/2012 6:01 AM, alex poyaoan wrote: Hi everybody have this cflayout name=tabtest type=tab cflayoutarea name=tab1 title=Data SJ source=tab1.cfm /cflayoutarea cflayoutarea name=tab2 title=Dati Personali source=personshowTab2.cfm !--- cfinclude template=personshowTab2.cfm --- /cflayoutarea cflayoutarea name=tab3 title=Storia in SJ cfinclude template=personshowTab3.cfm /cflayoutarea ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
problem on inserting null when option value is selected
Hi Everybody have this situation where I have a cfselect listed below with an added OPTION to display Please select province and a the list of provinces generated from a query which displays on the dropdown using the attribute QueryPosition=below. On the selected attribute the real value from the database should show from the query getdetails using #GetDetails.ProvID# which is ok. The problem now is when a value from the GetProvinces query is select all would be fine but when the added option with a blank value is select it stores the string Please select province on the database. How could I insert a null value when that is selected? CFSELECT NAME=TransProv Label=Transferred province QueryPosition=below query=GetProvinces value=ProvID display=provname selected=#GetDetails.ProvID# option value=Please select province/option /CFSELECT this is the action query to update the table cfquery name=UpdateSoc datasource=socs UPDATE Soc SET TransProv='#form.TransProv#' WHERE ID=100 /cfquery Thanks for any help alex ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Let queryParam do the work for you: UPDATE Soc SET TransProv = cfqueryparam cfsqltype=cf_sql_varchar value=#form.TransProv# null=#not len(form.TransProv)# / WHERE ID = cfqueryparam cfsqltype=cf_sql_integer value=100 / Hi I tried both your solutions but this time it inserts the quotes which is the value of the option and not a null value. Is there something wrong with my code? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332628 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Let queryParam do the work for you: UPDATE Soc SET TransProv = cfqueryparam cfsqltype=cf_sql_varchar value=#form.TransProv# null=#not len(form.TransProv)# / WHERE ID = cfqueryparam cfsqltype=cf_sql_integer value=100 / ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332629 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Let queryParam do the work for you: UPDATE Soc SET TransProv = cfqueryparam cfsqltype=cf_sql_varchar value=#form.TransProv# null=#not len(form.TransProv)# / WHERE ID = cfqueryparam cfsqltype=cf_sql_integer value=100 / ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332630 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Yes I tried it a couple of times but it still inserts the quotes. I tried a workaround which worked fine.. I inserted a value=1 to the blank option of the cfselect and did a cfif on the update query the code is listed below CFSELECT NAME=TransProv Label=Transferred province QueryPosition=below query=GetProvinces value=ProvID display=provname selected=#GetDetails.ProvID# option value=1Please select province/option /CFSELECT and here is the UPDATE QUERY. cfquery name=UpdateSoc datasource=socs UPDATE Soc SET TransProv=cfif (form.TransProv)neq 1'#form.TransProv#'cfelseNULL/cfif WHERE ID=100 /cfquery Thanks all for your help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfselect display problem
Thanks that did the trick!!! cfselect has SELECTED attribute - give it a variable that holds the value that should be selected. i.e. if you had selectedGroupID var that held the current GroupID value, you would use: cfselect ... selected=#selectedGroupID# for a multi-select you can provide a comma-delimited list of values that should be pre-selected. Azadi On 01/04/2010 16:46, alex poyaoan wrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfselect display problem
Hi Everybody... Have this situation wherein I have to display lsit from a query on a cfselect on enter mode which is OK with the cfselect listed below, but should display the real value of the GroupID from the database on edit mode cfselect query=getAll display=name value=GroupID /cfselect thanks for any help alex ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
problem with a condition cfif in a cfquery
HI everybody I have a table with two email addresses for every person there are cases though that emailaddr1 is empty and emailaddr2 has a value. I need to output the addresses that if emailaddr1 is empty it would be substituted by emailaddr2. I tried using a cfif inside the query written below but doesn't work cfquery name=recipients datasource=labels SELECT cfif (emailaddr1)eq emailaddr2, cfelse emailaddr1/cfif /cfquery cfoutput#recipients#/cfoutput thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331299 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem with a condition cfif in a cfquery
Got it I just forgot placing quotes on the (emailaddr1) on the cfif statement and now it works... thanks anyway HI everybody I have a table with two email addresses for every person there are cases though that emailaddr1 is empty and emailaddr2 has a value. I need to output the addresses that if emailaddr1 is empty it would be substituted by emailaddr2. I tried using a cfif inside the query written below but doesn't work cfquery name=recipients datasource=labels SELECT cfif (emailaddr1)eq emailaddr2, cfelse emailaddr1/cfif /cfquery cfoutput#recipients#/cfoutput thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem with a condition cfif in a cfquery
HI everybody I have a table with two email addresses for every person there are cases though that emailaddr1 is empty and emailaddr2 has a value. I need to output the addresses that if emailaddr1 is empty it would be substituted by emailaddr2. I tried using a cfif inside the query written below but doesn't work cfquery name=recipients datasource=labels SELECT cfif (emailaddr1)eq emailaddr2, cfelse emailaddr1/cfif /cfquery cfoutput#recipients#/cfoutput thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem with a condition cfif in a cfquery
THANKS DAVE THAT SOLVED IT!!! Alex, You can't use a CF condition within your SQL that you want to evaluate each record in the query. For that, you'd need to use an SQL condition. You could use CF conditions inside your cfquery only to evaluate the 'text' of the query (like to decide WHICH SQL statement to use for example based on values that exist apart from your data). You can use a 'isnull' function to solve this (this is a DATABASE function, not a CF function, and is, therefore, DB dependent). I'm not sure which DB you are using, but for SQL Server it's isnull. For Oracle it's NVL. cfquery name=recipients datasource=labels SELECT isNull(emailaddr1,emailaddr2) as emailaddr ... /cfquery This says, if emailaddr1 has a value, then return it as 'emailaddr', but if it is null, then return the value in emailaddr as 'emailaddr'. If emailaddr2 is also null, then 'emailaddr2' will be null. If you want another default value such as 'N/A', then you would just wrap it all with another function like this: SELECT isNull(isNull(emailaddr1,emailaddr2),'N/A') as emailaddr Hope this helps! Dave Phillips HI everybody I have a table with two email addresses for every person there are cases though that emailaddr1 is empty and emailaddr2 has a value. I need to output the addresses that if emailaddr1 is empty it would be substituted by emailaddr2. I tried using a cfif inside the query written below but doesn't work cfquery name=recipients datasource=labels SELECT cfif (emailaddr1)eq emailaddr2, cfelse emailaddr1/cfif /cfquery cfoutput#recipients#/cfoutput thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
problem with the output
Hi all am using cfmx7 and got a problem with the output of an ntext field.. On the database all of the data is there but on my cfoutput even on a cfdump it truncates the output.. the lenght of the data is 32223 characters with spaces... is there a limit on the cfoutput of ntext fields? thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem with the output
Thanks a lot Dave that got my outputs going... Hi all am using cfmx7 and got a problem with the output of an ntext field.. On the database all of the data is there but on my cfoutput even on a cfdump it truncates the output.. the lenght of the data is 32223 characters with spaces... is there a limit on the cfoutput of ntext fields? You must configure your datasource to allow the selection of the entire CLOB/BLOB field. Read the documentation to learn the details: http://livedocs.adobe. com/coldfusion/8/htmldocs/datasources_ADV_MJS_11.html#1278307 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
creating variables from a query problem
HI everybody,, Am stucked... I have a query with 9 rows. I need to store every row into a different distinct variable. my query is listed below cfquery name=getcs datasource=#datasource# SELECT COUNT(s.id) AS cscount FROMSociety s WHERE s.gr='cs' group by s.asst /cfquery cfoutput query=getcs startrow=1 maxrows=1 cfset row1=cscount /cfoutput cfoutput query=getcs startrow=2 maxrows=2 cfset row2=cscpimt /cfquery etc row9 I have to repeat the above code 9 times which is equivalent to the rows of my query...Is there a way of not doing this?.. thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: creating variables from a query problem
Thanks will do that then I need to store every row into a different distinct variable. You probably don't, and should instead be using an array. MyValues = ListToArray( ValueList( MyQuery.ColumnName ) ) Then you can do MyValues[1] to MyValues[9] to get at the variables. If you *really* need to create individual variables, you can then do: cfloop index=i from=1 to=#ArrayLen(MyValues)# cfset Variables['MyVariable#i#'] = MyValues[i] / /cfloop But don't do that - use the array. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem when modifying dates
Hi everybody.. Have a problem when i modify a date on a cfinput cfinput NAME=DateEnd TYPE=TEXT Value=#DateFormat(Getall.DateEnd, dd/mm/)# validate=eurodate width=150 I have a validate eurodate.. example I have a date that i should modify 20/01/2009 to 10/01/2009 (january 10, 2009) when i input it in the database and if the day is 12 and below it flips the day and month so it becomes 01/10/2009 (October 1, 2009) is there a way that it would stay as a eurodate? thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem when modifying dates
I tried it and it works fine but is it possible to type only the mmdd without dashes? On Thu, May 28, 2009 at 12:23 PM, alex poyaoan ap.cli...@tiscali.it wrote: cfinput NAME=DateEnd TYPE=TEXT Value=#DateFormat(Getall.DateEnd, dd/mm/)# validate=eurodate width=150 always insert dates in the following format... -mm-dd ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfmail validation
HI everybody am using cfmail with the code below.. my problem is with the query that get's all email addresses. If an email address is valid it goes if at one point emailaddress is not valid it gives an error. is there a way with my code to test valid email addresses or better then if there is a way that i could check which emails just went thru or not? CFPROCESSINGDIRECTIVE SUPPRESSWHITESPACE=NO CFMAIL QUERY=GetList SERVER=cbox.cbox.org SUBJECT=subject FROM=press service i...@info.org TO=#Trim(Name)# #Trim(Fname)# #Trim(emailaddr)# TYPE=HTML cfinclude template=pubSSMailDesign.cfm /CFMAIL /CFPROCESSINGDIRECTIVE thanks for any help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfmail validation
thanks will try this out... isValid(email, emailaddr) will tell you if it's a correctly formed email address, but not if it actually exists. This udf will check that a mailbox exists. Haven't tried it myself yet: http://cflib.org/udf/verifyEmail HI everybody am using cfmail with the code below.. my problem is with the query that get's all email addresses. If an email address is valid it goes if at one point emailaddress is not valid it gives an error. is there a way with my code to test valid email addresses or better then if there is a way that i could check which emails just went thru or not? CFPROCESSINGDIRECTIVE SUPPRESSWHITESPACE=NO CFMAILQUERY=GetList SERVER=cbox.cbox.org SUBJECT=subject FROM=press service i...@info.org TO=#Trim(Name)# #Trim(Fname)# #Trim(emailaddr)# TYPE=HTML cfinclude template=pubSSMailDesign.cfm /CFMAIL /CFPROCESSINGDIRECTIVE thanks for any help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322412 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
inserting datetime
HI everybody have this problem and could't get over it.. I have a flash form that insert date on an mssql 2000 db the format that is on the db field is dd/mm/... I display the date on a form and it displays right without doing anything and press ok on the form it flips the day and month ex 01/02/2009 (feb 1 2009) now is 02/01/2009 the insert statementi is CREATEODBCDATE(FIELDNAME) AND THE UPDATE IS THE SAME.. thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321392 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: inserting datetime
thanks will try this... When you use CreateODBCDate and pass in a string it will first try to convert it to a date using the US format of mm/dd/, and only if that fails will it try the rest-of-the-world format of dd/mm/. The same goes for some of the other CF date functions. So 12/13/2009 and 13/12/2009 will both get converted to 13th Dec 2009. :| IMO, the safest way to deal with dates coming in as strings (e.g. from forms etc) is to convert them to CF dateobjects using CreateDate as soon as you can using something like the following, though the error handling would obviously do something more friendly than just abort. cftry cfset myDateObject = CreateDate(ListGetAt(form.dateString, 3, '/'), ListGetAt(form.date, 2, '/'), ListGetAt(form.date, 1, '/')) cfoutput#myDateObject#/cfoutput cfcatch cfabort showerror=i couldn't make a date out of form.date... /cfcatch /cftry Assuming that the datatype of your dB column is DATETIME, you'll want to do something similar when displaying the date you pull out of the database, this time using DateFormat(yourDate, 'dd/mm/'). (N.B. DateFormat should be used to display a date object in a particular format, and not to try to create a date object from a string in a particular format...) As Peter mentioned, where possible it is preferable to use mmm is any dates you display to the end user as this removes any ambiguity between dd/mm vs. mm/dd: everyone understands Jan 2 2009 and 2 Jan 2009. Cheers Bert ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem to diplay results horizontally
hi everybody I have this code and it works fine except that i want the results of year to display horizontally couldn't figure out how toit grouped on the title CFOUTPUT query=GetAll group=title #GetAll.title# cfoutput ul li #year# /li /ul /cfoutput /cfoutput with this the results would be title1 2001 2002 2003 etc. I want the result to be title 2001 2002 2003 etc and on the 8th year it would break thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem to diplay results horizontally
ok thanks will try that correction it's not default to block.. it's list-item... the element li display property is defaulted to block, try setting up some css, change the inline property of the li element to inline. I'm no css guru but that might get your started ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem to diplay results horizontally
Yes thanks got it and working fine with display: inline; Try this Always works for me .ul{ margin: 0; padding: 0; cursor: default; list-style-type: none; display: inline; } .li{ display: table-cell; position: relative; padding: 2px 6px; display:inline; } Thanks! Robert Bailey 210.748.2363 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
uploading file on a different server using cffile
HI everybody Is there a way of uploading file on a different server other than what i'm using.. if i try to upload it locally with a cffile it works but my plan is uploading it to another one because of space problems.. thanks for any help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316250 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with sum of resuts of two queries
HI everybody just wondering if there is a way i could sum the results of two queries and display it inside of cfoutput.. the queries are below CFQUERY NAME=total1 datasource=db1 SELECT COUNT(id1) AS Expr1 FROMtable2 /CFQUERY CFQUERY NAME=total2 datasource=db1 SELECT COUNT(id1) AS Expr1 FROMtable1 /CFQUERY like cfoutput #total1.expr1#+#total2.expr2# /cfoutput but the above doesn't work thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with sum of resuts of two queries
thanks all for the quick reply it worked HI everybody just wondering if there is a way i could sum the results of two queries and display it inside of cfoutput.. the queries are below CFQUERY NAME=total1 datasource=db1 SELECT COUNT(id1) AS Expr1 FROM table2 /CFQUERY CFQUERY NAME=total2 datasource=db1 SELECT COUNT(id1) AS Expr1 FROM table1 /CFQUERY like cfoutput #total1.expr1#+#total2.expr2# /cfoutput but the above doesn't work thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable do you store the event's end month or full date or duration in the db, too? what are the fields? how about events that start in one year and end in the next??? post your db table structure (with data types and explanations of what data is stored in the filed if not clear from filed name). Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem displaying event if it ends on the succeeding month
HI below is the structure of the db table and yes also instances from one year to the other columnnamedatatype allownulls EventID int Unchecked StartDate datetime Checked EndDate datetime Checked EventInfo nvarchar(255) Checked Type int Checked do you store the event's end month or full date or duration in the db, too? what are the fields? how about events that start in one year and end in the next??? post your db table structure (with data types and explanations of what data is stored in the filed if not clear from filed name). Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
columnname datatype allownulls EventIDintUnchecked StartDate datetime Checked EndDatedatetime Checked EventInfo nvarchar(255)Checked Type int Checked above is the structure of dbtable ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem displaying event if it ends on the succeeding month
hi Sorry for that and for the post that are doubled it seemed to me that it's not posting because it took a while to see it so i resent it again many times... anyway the startyear and eventmonthstart comes from a cfset i declared before the query which takes the datepart(, startdate) and datepart(m, Startdate) so the query would be this if it would go right cfquery name=GetEvents datasource=sql1 SELECT * FROM GetEvents WHERE datepart(, StartDate) = #form.YearChosen# AND Datepart(m, StartDate) = #form.MonthChosen# ORDER By StartDate /cfquery thanks again alex and i do not see any StartYear or EventMonthStart columns in there... the columns in the query you originally posted? where are they coming from? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem displaying event if it ends on the succeeding month
IT IS MSSQL 2000 what's your db? ms sql? mysql? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with cfif conditions on dates
Thanks so much that did it .. It's just so simple but i've complicated myself from my original code.. again thanks all you need for your desired output is: cfquery ... ... /cfquery cfoutput query=getevents #StartDate#cfif startdate neq enddate - #EndDate#/cfif /cfoutput however, keep in mind that if your startdate and enddate db fields also include TIME part, your stratdate will not be equal to enddate even if date parts are same... you will need to use your db's date/time functions to select only the DATE part of these fields and compare/output those. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with cfif conditions on dates
HI everybody have this problem with this query.. CFQUERY NAME=GetEvents DATASOURCE=events SELECT c.startdate, c.endDate FROM CalendarEvents c /CFQUERY cfoutput cfif #getevents.StartDate# eq #getevents.EndDate# cfset EndDate= cfset hyphen= cfelse cfset EndDate=#getevents.enddate# cfset hyphen=- /cfif /cfoutput cfoutput query=getevents #StartDate# #hyphen# #EndDate# /cfoutput With the conditional statement cfif if the startdate = enddate i need only to see the startdate without the hyphen otherwise it gives me both dates with the hyphen .. my code above doesn't work ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem displaying event if it ends on the succeeding month
HI everybody Got this situation that i need to display events depending on the month selection form.month it works fine when the event duration is within the month but i also need to display the duration enddate would be going over the following month or more... below is my code... cfquery name=GetEvents datasource=sql1 SELECT * FROM GetEvents WHERE StartYear = #form.YearChosen# AND EventMonthStart = #form.MonthChosen# ORDER By StartDate /cfquery cfoutput query=GetEvents #startdate# - #enddate# - #description# /cfquery result would be: this taking into consideration that the selection form.yearchosen = 2008 and form.monthchosen = january which has a value of 1 01/01/2008 - 01/10/2008 - meeting 1 01/05/2008 - 02/10/2008 - conference 01/20/2008 - 03/10/2008 - class the problem arises when the selection would be: if form.yearchosen = 2008 form.monthchosen = february value 2 the second record and the third record would still appear on the result which is still ongoing in february. 01/05/2008 - 02/10/2008 - conference 01/20/2008 - 03/10/2008 - class etc. couldn't figure out how to deal with it. thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
help on persistent variable on 3 cfm templates
HI everybody. have this problem which I couldn't seem to solve.. I have three templates. I have to declare a variable that would persist in these three templates. On the index page is a url variable that is passed to magazine.cfm and from the magazine.cfm to magarticles.cfm.. this after the action page it comes back to magazine.cfm.. but it gives me an error which is that url.magazineid is undefined... index.cfm magazine.cfm?magazineid=#UrlEncodedFormat(getall.magazineid)# magazine.cfm magarticles.cfm thanks for any help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on persistent variable on 3 cfm templates
Are you using Firefox? I suggest you do go and d'load that and install it. Then grab yourself a copy of fireBug and install that into firefox. The best thing about this plugin, that information can be seen or not going through the URL and can be debugged if your code is wrong or not. Because you will see what is being passed in the URL? Also you do not say which version of Coldfusion you are using, but if you are using Coldfusion 8 then I suggest reading a bit more on line debugging, and you can debug your code that way. Not using Coldfusion 8, then I suggest looking at fusionDebug as a good addition to your Eclipse (oh did Iask that) anyway there are some great tools for this at your disposal. I suggest maybe looking into one or more of these. Now for your problem, you could do a cfdump var=#URL# and then abort the page to see if the values are going across, and that you are indeed passing them via the url. However, if it was me. And you don't indicate any more than the vars not being there in the URL. But I would be maybe looking at what framework your using, none then double check your links. but I would be looking at what information these other pages need to share? Could it be stored in the application scope (available to all the application) or could it be held in the session. Eitherway, it could be a case that you could repull this info at anytime without passing it back and forth. But this is something you will need to look at when it comes to sharing the data from one page to the next. I hope I haven't confused you too much, but the tools I mentioned with firefox are invaluable to you and debugging passing of URL / Rest and other information from client to server. Plus you get all the added benefits of modifying your css and html and JS, huge benefit to use. But as I said, if you look at what you are passing around. Then you could decide what scope to hold that info in, or not. And decide whether or not you need to rehit the database or not. Plenty of options open to you, if you dig deeper into your requirement. Hi Andrew Thanks for your advise will be trying what you said.. And to clarify things more.. yes i'm using firefox so will try firebug... also am using coldfusion mx7... Well the url variable coming from the index.cfm template is going thru magazine.cfm page. my problem is when i add a magazine article on magazinearticle.cfm on the action page I HAVE THE cflocation url=magazine.cfm so it gets me back to that page and naturally the url which was passed earlier is gone already so it gives an error url undefined I tried a session variable with it but couldn't go thru.. thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on persistent variable on 3 cfm templates
thanks got it thru but i created a session variable this time from the url and struct clear it everytime the same user edits or adds new magazine articles I don't know it it is a good idea using session variable for these three pages... Why can't you just add the URL variable to the CFLOCATION...? ie. cflocation url=magazine.cfm?variable=#id# or whatever Thanks for your advise will be trying what you said.. And to clarify things more.. yes i'm using firefox so will try firebug... also am using coldfusion mx7... Well the url variable coming from the index.cfm template is going thru magazine.cfm page. my problem is when i add a magazine article on magazinearticle.cfm on the action page I HAVE THE cflocation url=magazine.cfm so it gets me back to that page and naturally the url which was passed earlier is gone already so it gives an error url undefined I tried a session variable with it but couldn't go thru.. thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cflocation problem
thanks to all the inputs will try which is best ... Hi everybody need help on this I have this code on an action template CFQUERY NAME=AddHL datasource=db INSERT into table1(listID, secondID, emailID) VALUES('#Form.ListID#','#Form.secondID#','#form.emailID#' ) /cfquery CFLOCATION URL='Form2.cfm' I need to go back to the previous form with the value of form.id which comes from the calling template. Is there a way to insert that value in the cflocation url? I tried it but it gives me an error wHAT i WANT TO DI IS cflocation url='form2.cfm?id='form.id thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cflocation problem
Hi everybody need help on this I have this code on an action template CFQUERY NAME=AddHL datasource=db INSERT into table1(listID, secondID, emailID) VALUES('#Form.ListID#','#Form.secondID#','#form.emailID#' ) /cfquery CFLOCATION URL='Form2.cfm' I need to go back to the previous form with the value of form.id which comes from the calling template. Is there a way to insert that value in the cflocation url? I tried it but it gives me an error wHAT i WANT TO DI IS cflocation url='form2.cfm?id='form.id thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304741 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with passing variables to action template
Hi every body have this problem and couldn't find the solution have one table to update with data from another table have two templates the first has two queries which are cfquery name=get datasource=source select tid, name FROM info WHERE 1id=10 /cfquery CFQUERY NAME=Check datasource=source SELECT 1id, 2id FROM tb2 WHERE Nome LIKE '%#RECORD#%' /CFQUERY on the second template I have this update query but data should be coming from the first template how could I pass the values of 1id and 2 id to update it on the info table? will i use cfparam for it UPDATE info SET 1ID=#url.id1# WHERE tid=#url.tid# AND 2ID=#url.id2# WHERE tid=#url.tid# thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with passing variables to action template
Hi every body have this problem and couldn't find the solution have one table to update with data from another table have two templates the first has two queries which are cfquery name=get datasource=source select tid, name FROM info WHERE 1id=10 /cfquery CFQUERY NAME=Check datasource=source SELECT 1id, 2id FROM tb2 WHERE Nome LIKE '%#RECORD#%' /CFQUERY on the second template I have this update query but data should be coming from the first template how could I pass the values of 1id and 2 id to update it on the info table? will i use cfparam for it UPDATE info SET 1ID=#url.id1# WHERE tid=#url.tid# AND 2ID=#url.id2# WHERE tid=#url.tid# thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with passing variables to action template
How are you getting from page one to page two? You're using URL vars in the second page so I'm guessing a link of some sort? Page 1: QUERY HERE cfloop query=yourQuery a href=page2.cfm?tid=#yourQuery.tid#Do something/abr / /cfloop If that's not enough, supply more info about your problem. Adrian that solved it thanks Hi every body have this problem and couldn't find the solution have one table to update with data from another table have two templates the first has two queries which are cfquery name=get datasource=source select tid, name FROM info WHERE 1id=10 /cfquery CFQUERY NAME=Check datasource=source SELECT 1id, 2id FROM tb2 WHERE Nome LIKE '%#RECORD#%' /CFQUERY on the second template I have this update query but data should be coming from the first template how could I pass the values of 1id and 2 id to update it on the info table? will i use cfparam for it UPDATE info SET 1ID=#url.id1# WHERE tid=#url.tid# AND 2ID=#url.id2# WHERE tid=#url.tid# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problem with form field undefined
HI everybody below is the error which Coldfusion gives me: Element PID is undefined in TESTFORM. (this is the error that coldfusion gives me as soon as I press the ok button that should update the info table) action.cfm The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 2 : UPDATE info 3 : SET 4 : pID = #form.PID#, 5 : sID = #form.SID# 6 : WHERE id=#form.ID# I have this form on the first template that calls the action.cfm it gets it's data from a query named check cfoutput CFFORM ACTION=action.cfm format=xml skin=lightgray width=500 preservedata=yes METHOD=Post !--- cfinput type=hidden name=Tab value=1 --- cfinput type=text name=PID value=#check.PID# cfinput type=text name=SID value=#check.SID# cfinput type=text name=ID value=#check.ID# cfinput type=submit name=Submit value= ok /cfform /cfoutput I don't know what's getting this error since PID is defined in the form please help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problem with form field undefined
HI everybody below is the error which Coldfusion gives me: Element PID is undefined in TESTFORM. (this is the error that coldfusion gives me as soon as I press the ok button that should update the info table) action.cfm The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 2 : UPDATE info 3 : SET 4 : pID = #form.PID#, 5 : sID = #form.SID# 6 : WHERE id=#form.ID# I have this form on the first template that calls the action.cfm it gets it's data from a query named check cfoutput CFFORM ACTION=action.cfm format=xml skin=lightgray width=500 preservedata=yes METHOD=Post !--- cfinput type=hidden name=Tab value=1 --- cfinput type=text name=PID value=#check.PID# cfinput type=text name=SID value=#check.SID# cfinput type=text name=ID value=#check.ID# cfinput type=submit name=Submit value= ok /cfform /cfoutput I don't know what's getting this error since PID is defined in the form please help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
Hi Adrian with that cfdump it gives me this struct struct FIELDNAMES SUBMIT,PID,SID,ID INFID 18276 PID 17047 SID 17734 SUBMIT associate all of it is defined but still it gets the undefined error on the form thanks To see what's in the FORM scope, add this above the point it errors. cfdump var=#FORM# cfabort See what that shows you. Adrian http://www.adrianlynch.co.uk/ HI everybody below is the error which Coldfusion gives me: Element PID is undefined in TESTFORM. (this is the error that coldfusion gives me as soon as I press the ok button that should update the info table) action.cfm The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 2 : UPDATE info 3 : SET 4 : pID = #form.PID#, 5 : sID = #form.SID# 6 : WHERE id=#form.ID# I have this form on the first template that calls the action.cfm it gets it's data from a query named check cfoutput CFFORM ACTION=action.cfm format=xml skin=lightgray width=500 preservedata=yes METHOD=Post !--- cfinput type=hidden name=Tab value=1 --- cfinput type=text name=PID value=#check.PID# cfinput type=text name=SID value=#check.SID# cfinput type=text name=ID value=#check.ID# cfinput type=submit name=Submit value= ok /cfform /cfoutput I don't know what's getting this error since PID is defined in the form please help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
Your error is Element PID is undefined in TESTFORM, meaning you are referenceing Testform.PID somewhere. That reference isn't in your posted code, so you'll need to check your pages and see where that is coming from. SORRY FOR THAT because I named the form testform and it still gives me that error and eliminating the name of the form Element PID is undefined in FORM and in fact with cfdump var='#FORM#' it gives me all the values and I couldn't find anything from the cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
What is odd is that the message says '... is undefined in TESTFORM' as opposed to '... is undefined in FORM'. Are you using 'testForm' anywhere where you should be using just 'form' (I realise the error is being generated at line 4 but that message is odd)? Dominic Hi sorry for that .. the error for pid is undefined on testform came when i named the form testform but deleting the name of the form . is undefined in the form came up thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
HI as quoted that error came when i named the cfform testform and also deleting the name it gives me now the PID is undefined in FORM and with the cfdump all of the variables is displayed and defined thanks again The error is saying PID is undefined in TESTFORM. Do you have TESTFORM.pid anywhere? Adrian Hi Adrian with that cfdump it gives me this struct struct FIELDNAMES SUBMIT,PID,SID,ID INFID 18276 PID17047 SID17734 SUBMIT associate all of it is defined but still it gets the undefined error on the form thanks table) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem with form field undefined
yes the error occurs in action.cfm but if you cfdump form all of the required variables has values as what i posted earlier 1) the error refers to TESTFORM... which page has #TESTFORM.PID# in it? 2) in your posted code the ACTION attrib of your cfform tag is set to 'action.cfm'... the error states it occurred in page 'db1.cfm'... some template confusion going on? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with listgetat
Hi everybody.. havinng a problem with listgetat and couldn't seem to find the solution.. please help my code is cfif GetEmail.RecordCount IS 1 cfset emaillist=#getemail.email# cfset email1=#trim(ListFirst(emaillist))# cfelseif getemail.Recordcount is 2 cfset emaillist=#getemail.email# cfset email1=#trim(listGetAt(emaillist, 1))# cfset email2=#trim(listGetAt(emaillist, 2))# cfelse cfset emaillist=#getemail.email# cfset email1=#trim(listGetAt(emaillist, 1))# cfset email2=#trim(listGetAt(emaillist, 2))# cfset email3=#trim(listGetAt(emaillist, 3))# I have a query getemail with one email only it goes okey if two or three it throws these error Invalid list index 2. In function ListGetAt(list, index [, delimiters]), the value of index, 2, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list. The error occurred in C:\CFusionMX7\wwwroot\devcurianet\riservate\socialMail\subscriberForm.cfm: line 60 58 :cfset emaillist=#getemail.email# 59 :cfset email1=#trim(listGetAt(emaillist, 1))# 60 :cfset email2=#trim(listGetAt(emaillist, 2))# .. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem with listgetat
getemail.email isn't automatically converted to a list - it will refer to only the first record in the query. You're better off just referring to the query value directly and doing it all in a loop so it can deal with any number of email addresses (it's certainly less code): cfloop query=getemail cfset email#getemail.CurrentRow# = getemail[email][getemail.CurrentRow] /cfloop On Mon, Apr 14, 2008 at 5:32 PM, alex poyaoan [EMAIL PROTECTED] wrote: thanks for the reply trying it and gave me the list of email but with a suffix of getemail.currentrow how could we avoid that sorry didn't get ir right maybe ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303272 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
forwarding a session url in an included template
Hi everybody need help on how i could forward a url session variable in an included template I have two files first is index.cfm the main page and header.cfm the included page I have a page home.cfm which calls index.cfm my code is this on the index.cfm cfif IsDefined(URL.Language) cfset Session.Language=URL.Language /cfif cfif NOT IsDefined(Session.Language) cfset Session.Language=1 /cfif outputting session.language on a cfdump on the index.cfm page outputs ok but not on the header.cfm page... which also i tried transferring the code to header.cfm thanks alex ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
help on variable undefined on a url.variable
Hi everybody... Am having difficulty resolving this variable id undefined... have this code on my first.cfm a href=second.cfm?id=#UrlEncodedFormat(id)#result/a this link eventually calls second.cfm which passes the varible url.id on a query on the second form.. cfquery name=name datasource=source select name, id from tblname where id=#url.id# /cfquery the above code works fine and perfect on the live web site but throws the error on my development server in my computer (variable id undefined)... is ther anything i must configure on my local coldfusion inorder that it works? thanks ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283525 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on variable undefined on a url.variable
Thanks Mike for your advice it resolved the problem you're right it is not the url that is being passed.. the only strange thing is it works online is ther any explanation for it? thanks alex First of all, i'd suggest using CFQueryparam to help secure against nasties in your SQL statement.Your query should be something like: cfquery name=name datasource=source select name, id from tblname where id = cfqueryparam value=#url.id# cfsqltype=cf_sql_integer / /cfquery That doesnt answer your original question, but it will be essential for you to protect yourself against someone changing the url variable for that page to something like: second.cfm?id=412'Drop table users' or adding other SQL nasties to your URL. To you question.I think you should have a look at what's actually being handed to your page. You THINK It's your ID, but maybe it's not. Do a CFDUMP of the URL on the second.cfm page and see what's being handed in after the URLEncoding happens. cfdump var=#url#cfabort somewhere in the second.cfm page will make the page stop at that point and display for you exactly what's being passed to that page. It might not be what you think it is. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 7/12/07, alex poyaoan [EMAIL PROTECTED] wrote: thanks ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283529 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
conditional statements in a .cfr or report builder
HI everybody.. am new to report builder and just wondering where i will be placing the conditional statements.. my case is for the location of zip code for address meaning 1, 2, 3, 4 when it is 1 to the left of the city when 2 to the right , 3 left of country 4 right of country.. I usually do this with this cfif statement in a cfm page but with .cfr couldn't figure out where i'll be placing it.. cfif #zipcodepos# is '' #zipcode#nbsp; #city#br #coujntry# cfelseif #zipcodepos# is 1 #city# nbsp;#zipcode# br #country# cfelseif #zipcodepos# is 2 #city#br #zipcode# nbsp;#country cfelse #city #country##zipcode# /cfif the above works well with cfm where will i place it in a .cfr or coldfusion report any help please thanks ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: conditional statements in a .cfr or report builder
Sounds like you need to create a calculated field in your .cfr file. That cfif statement would be the calculation. Then you'd just use that new calculated field in the layout of your report. Make sense? Cheers, Kris On 7/4/07, alex poyaoan [EMAIL PROTECTED] wrote: Can you please elaborate further Kris.. tried it but couldn't go further thanks ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on dynamic position of fields in cfoutput for postal code
Thanks that did the trick... cfoutput query=test cfif position is 1 #CITY# #CODE# cfelse #CODE# #CITY# /cfif /cfoutput .. :.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:15 AM To: CF-Talk Subject: help on dynamic position of fields in cfoutput for postal code HI everybody... need help on how to position the postal code on either left or right of the city depending on the given value.. have this table CITY CODE POSITION CITYA 001001 CITYB 12 IF POSITION IS 1 THE CODE SHOULD BE ON THE RIGHT OF THE CITY cfoutput query=test #CITYA# #CODE# /cfoutput IF POSITION IS 1 THE CODE SHOULD BE ON THE LEFTOF THE CITY cfoutput query=test #CODE# #CITYB# /cfoutput is there a way of doing this dynamically.. THANKS.. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
help on dynamic position of fields in cfoutput for postal code
HI everybody... need help on how to position the postal code on either left or right of the city depending on the given value.. have this table CITY CODE POSITION CITYA 001001 CITYB 12 IF POSITION IS 1 THE CODE SHOULD BE ON THE RIGHT OF THE CITY cfoutput query=test #CITYA# #CODE# /cfoutput IF POSITION IS 1 THE CODE SHOULD BE ON THE LEFTOF THE CITY cfoutput query=test #CODE# #CITYB# /cfoutput is there a way of doing this dynamically.. THANKS.. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282366 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Error Executing Database Query
need help for this message.. the object db.soc is existing below is my query and the error it throws: I'm using mssql server 2005 express edition cfquery name=all datasource=soc SELECT TOP (100) PERCENT SocID, Pr, FROM dbo.soc ORDER BY Pr Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Soc'. thanks a lot for any help ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281226 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error Executing Database Query
Got it functioning!!! The solution is to declare explicitly after the datasource= the dbnamedatabasename dbtype=ODBC is there a configuration that i should do on coldfusion or mssql inorder that this error won't go out.. thanks ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error Executing Database Query
I am sure DBTYPE has been deprecated in MX as all connections are JDBC. What connection type did you set up? An ODBC or normal SQL one? You also do not need to prefix the table with dbo in your case. the connection is ODBC is it better if i set up SQL to avoid this? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: alex poyaoan To: CF-Talk Sent: Fri Jun 15 08:05:02 2007 Subject: Re: Error Executing Database Query Got it functioning!!! The solution is to declare explicitly after the datasource= the dbnamedatabasename dbtype=ODBC is there a configuration that i should do on coldfusion or mssql inorder that this error won't go out.. thanks ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281236 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error Executing Database Query
I am sure DBTYPE has been deprecated in MX as all connections are JDBC. What connection type did you set up? An ODBC or normal SQL one? You also do not need to prefix the table with dbo in your case. THE CONNECTION IS ODBC IS IT BETTER IF I SET UP SQL TO AVOID THAT AND NOT DECLARING IT EXPLICITLY? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: alex poyaoan To: CF-Talk Sent: Fri Jun 15 08:05:02 2007 Subject: Re: Error Executing Database Query Got it functioning!!! The solution is to declare explicitly after the datasource= the dbnamedatabasename dbtype=ODBC is there a configuration that i should do on coldfusion or mssql inorder that this error won't go out.. thanks ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281237 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with rotating news
Hi everybody I need help on how could i achieve rotating news.. I have 12 news items on the database and i want it to rotate it showing only 3 items everytime i refresh the page.. tried using top 3 but how could i rotate it.. thanks to all ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem with rotating news
thanks will try it we're using ms sql 2000 so i guess that is available... ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
getting a part of a field
Hi everybody need help on this.. i have this code SELECT NAME=PJ CFOUTPUT QUERY=searchp OPTION VALUE=#PubCode##pubcode#/OPTION /CFOUTPUT /SELECT it gets iits value on a field on a database which has this format 200603092 what i need to show to user is the last three digits is is 092 BUT THE VALUE MUST REMAIN THE SAME.. i couldn't figure out how to do that.. any help please ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: getting a part of a field
thank you so much that helped me a log Perhaps, this? SELECT NAME=PJ CFOUTPUT QUERY=searchp OPTION VALUE=#PubCode##right(pubcode, 3)#/OPTION /CFOUTPUT /SELECT -Original Message- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 27, 2007 8:44 AM To: CF-Talk Subject: getting a part of a field Hi everybody need help on this.. i have this code SELECT NAME=PJ CFOUTPUT QUERY=searchp OPTION VALUE=#PubCode##pubcode#/OPTION /CFOUTPUT /SELECT it gets iits value on a field on a database which has this format 200603092 what i need to show to user is the last three digits is is 092 BUT THE VALUE MUST REMAIN THE SAME.. i couldn't figure out how to do that.. any help please ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problem with a file extension
Hi everybody need help on this... have 10 pictures which rotates everyday on my web page.. the names and description are fed on the database which the problem is the name of the file doesn't include the extension .jpeg i need to include that in the cfoutput tried it but the pictures doesn'ìt show.. if i insert .jpg on each picture name in the database it is ok is there a possibility that i could include the extension on the cfoutput? i tried inserting with the code below but it gives me always an error. cfoutput img src=images/#foto.name[fotoNum]#'.jpg width=640 height=180 border=0 /cfoutput thanks ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:28 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with a file extension
thanks Rich so this is the code cfquery name=foto datasource=webphotos SELECT * FROM photos /cfquery !---declare fotonum variable relative to date converted to integer and use mod to turn that daily number into a recurring cycle --- cfset fotoNum = (int(now()) mod foto.recordCount) + 1 cfoutput img src=images/#foto.name[fotoNum]#'.jpg' width=640 height=180 border=0 /cfoutput BELOW IS THE RESULT OF THE CFDUMP DESCRIPTION NAME PHOTOID 1 picture 1 foto1 1 2 picture 2 foto2 2 3 picture 3 foto3 3 4 picture 4 foto4 4 it doesn't give an error but it doesn't show the picture thanks again Alex I am not sure that you need that extra' in the middle of here [fotoNum]#'.jpg Have you tried dumping the contents of foto to make sure you have the data that you need and are you also sure that fotoNum has a numerical value that you require? It may be helpful for these emails if you post the error message or part of it to give people more of a clue as to what is happening. Also, there is no '' on your opening cfoutput but that may well be an email and typo or missed of a 'copy and paste'. On 1/16/07, alex poyaoan [EMAIL PROTECTED] wrote: ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem with a file extension
Yes Rich thanks i added the jpg on the filename and it resolved everything and on the properties it gives me the filename right.. again thanks Did you try removing the seemingly extra single quote mark before .jpg? This will be added to your file name and it may be that you don't need this? If there is no error, is there a blank image placeholder where the image should be? If there is, right click on it and select properties and it should tell you the path and image name that has been output and this may give you more clues as to what is going wrong with the file name. On 1/16/07, alex poyaoan [EMAIL PROTECTED] wrote: ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
help on character set for cfmail
Hi everybody... we set up a mailing system that sends headlines to many people but in different languages.. for the english one's we got no problem but the SPANISH - FRENCH -ITALIAN sometimes doesn't see characters with accents.. is it due to the declared character set? which currently we are using UTF-8 we also tried using this characters charset=ISO-8859-1 but it gives us the same error... any help is much needed.. thanks alex ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on character set for cfmail
alex poyaoan wrote: accents.. is it due to the declared character set? which currently we are using UTF-8 we also tried using this characters charset=ISO-8859-1 but it gives us the same error... is the non-english text ok before you send it? is your data indeed encoded as unicode? what ver of cf? sent as plain text? html? the non english ones before sending is ok the cf version is mx7 and is sent as plain text.. sorry but couldn't understand encoded as unicode... ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on character set for cfmail
alex poyaoan wrote: the non english ones before sending is ok the cf version is mx7 and is sent you can dump the out ok via cf? as plain text.. sorry but couldn't understand encoded as unicode... what encoding for the data? where's the data coming from? the data is coming from a plain text document copied and pasted on a form field and sent via the cfmail the actual code is this.. CFMAIL SUBJECT=#Form.Subject# FROM=Headlines [EMAIL PROTECTED] TO=[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED] SERVER=cbox.org.org charset=utf-8 #FORM.MessageBody# /CFMAIL ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on character set for cfmail
alex poyaoan wrote: the non english ones before sending is ok the cf version is mx7 and is sent you can dump the out ok via cf? as plain text.. sorry but couldn't understand encoded as unicode... what encoding for the data? where's the data coming from? the data is coming from a plain text document copied and pasted on a form field and sent via the cfmail the actual code is this.. CFMAIL SUBJECT=#Form.Subject# FROM=Headlines [EMAIL PROTECTED] TO=[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED] SERVER=cbox.org.org charset=utf-8 #FORM.MessageBody# /CFMAIL forgot to include that we test the accents and send it to our emails and it all goes right but sending it to people specially in africa some of them doesn't see it.. is there a setting from their email programs for it .. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on character set for cfmail
alex poyaoan wrote: the data is coming from a plain text document copied and pasted on a form and is that page utf-8 encoded? can you send me a test email? Yes it is utf-8 encoded yes i can send you an email or what it looks like on the clients emails ... can you give me your email address ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on character set for cfmail
alex poyaoan wrote: the data is coming from a plain text document copied and pasted on a form and is that page utf-8 encoded? can you send me a test email? Yes it is utf-8 encoded yes i can send you an email or what it looks like on the clients emails ... can you give me your email address I found the source of the problem and will be explaining it here maybe it could be help to others.. most of the people who does not see right the characters with the utf-8 encoded message, use eudora client so if that happens they have to download the eudora plugin ISO plugin V1.60 for Eudora (11/2006) from their website and install it then restart the client and all would be fine... ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
help on displaying 1 photo daily
HI everybody am trying to figure out trying to rotate a series of photos daily on my page is there an application that does that? please help me with this.. thanks ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263509 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on displaying 1 photo daily
tnanks Doug that thing worked ... will be trying other methods but is going fine this way Well, you could do it simply based on your image name. IE: rename your images based on days in a month 1-31 and then pull your image based on what day it is. I am sure someone on here can find a more sexy way, but this is one way. You can also do it yearly using dayOfYear() if you have that many images. !---define our image var--- cfset myDailyImage = #Day(Now())# !---display the image--- img src=images/#mydailyImage#.jpg Doug - Original Message - From: alex poyaoan [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, December 11, 2006 2:32 AM Subject: help on displaying 1 photo daily HI everybody am trying to figure out trying to rotate a series of photos daily on my page is there an application that does that? please help me with this.. thanks ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263513 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problem on cfoutput query syntax too complex for cfmx
Hi everybody need help on the following: I have two cfquery which are cfquery name=english datasource=db select * from lang where langid=1 /cfquery cfquery name=spanish datasource=db select * from lang where langid=2 /cfquery cfparam name=Session.Lang default=1 CFSWITCH expression=#Session.Lang# cfcase Value=1 cfoutput cfset qtext=#english# /cfoutput /cfcase cfcase Value=2 cfoutput cfset qtext=#spanish# /cfoutput /cfcase /cfswitch cfoutput query=#qtext# #field1# /cfoutput the error is coming from cfoutput query which says Complex object types cannot be converted to simple values. IS THERE A WAY TO POST THE QUERY DYNAMICALLY IN THE CFOUTPUT I HAVE BEEN TRYING MANY METHODS BUT COULDN'T GET IT THANKS ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem on cfoutput query syntax too complex for cfmx
scrap the hashes. cfset qtext=spanish cfoutput query=qtext On 04/12/06, alex poyaoan [EMAIL PROTECTED] wrote: THANKS A LOT ADRIAN THE CODE NOW WORKS.. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
help on cfquery and cfoutput
help on this please the code is CFQUERY NAME=NewsUpdates datasource=dbweb SELECT Title,Content FROMPubContent WHERE PubcontentId BETWEEN 3703 AND 3705 /CFQUERY the above query gives me three records.. the problem is how to display each record in three different sections of the template... is there a way to insert a parameter like pubcontentid=3703 inside the cfoutput creating each for every record? thanks for any help... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on cfquery and cfoutput
Thanks to both of you now it is outputing what i want and in different sections. 1) Refer to the query using array notation: cfoutputTitle: #NewsUpdates.Title[1]# Content: #NewsUpdates.Content[1]#/cfoutput cfoutputTitle: #NewsUpdates.Title[2]# Content: #NewsUpdates.Content[2]#/cfoutput etc OR 2) If you don't know which row is which, use QoQ to select the one you need at each point in the template. On 11/30/06, alex poyaoan [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
help on uploading files using forms
HI everybody.. Is there a way of uploading files to a directory on the server using forms or cfform type flash...? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262190 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
help on update query
Hi everybody need help on this update query which gives me a syntax error.. but couldn't see where.. this is the code CFQUERY NAME=UpdateMyPass DATASOURCE=auxdb UPDATE tblpassword SET PASSWORD = '#Form.strPasswd#' WHERE PASSWORD_ID = #URL.PASSWORD_ID# /cfquery with this i have a flash form from a mykey.cfm which calls mykey_action.cfm where the update query is.. but gives syntax error thanks in advance ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on update query
Are you sure that URL_PASSWORD_ID had a value otherwise it may be executing: WHERE PASSWORD_ID = Output the variable before running the query to make sure that it isn't this On 11/10/06, alex poyaoan [EMAIL PROTECTED] wrote: Hi Rich, Well the variable i guess is coming up since this is the url on the page http://localhost/auxweb/riservate/mykey_action.cfm?PASSWORD_ID=4 with the correct password_id with the call i didn't place a URLENCODEDFORMAT Though but placing it it doesn't give me the correct password_id ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on update query
PASSWORD is a reserved word for many DBs; try [PASSWORD] as the column name instead. On 11/10/06, alex poyaoan [EMAIL PROTECTED] wrote: Thanks James it worked so i'll try not to use password as a field because as you said it is a reserved word.. again thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on the cfif code
Hi all Thanks for all your clarifications with all the testing and the cfdumps you suggested I resolved everything with that with a cfoutput after the cfif and another at the cfelse... Just got the idea with the code that Rich suggested earlier and with the cfdump after the cfif and cfelse it confirmed the result which I want but on the real code the no risorse comes up... so i tried the code below and it all came up well THANKS ALL FOR YOUR HELP... CFIF risorse.recordcount GT 0 cfoutput a class=continuasmall href=#LINKRISORSE#?INSEGNAMENTO_ID=#UrlEncodedFormat(INSEGNAMENTO_ID)# target=_blank#DESCRIZIONERISORSE#/a /cfoutput cfelse cfoutput pno risorse/p /cfoutput /cfif ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
help on the cfif code
hi everybody i have this code that checks if the recordcount of the query is not equal to 0 it gives me the list if not on the cfelse it should give me a message but it just doesn't the list is blank... thanks so much just trying to for hours but couldn't just get what i want CFIF risorse.recordcount IS NOT 0 a class=continuasmall href=#LINKRISORSE#?INSEGNAMENTO_ID=#UrlEncodedFormat(INSEGNAMENTO_ID)# target=_blank#DESCRIZIONERISORSE#/a cfelse pno risorse/p /CFIF thanks alex ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258220 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on the cfif code
Alex That code seems to work ok ... I am not sure I understand exactly what your problem is ... I am getting a link if there are records from the query and a message if there isn't any records Can you explain more about what your poblem is? Rich On 10/27/06, alex poyaoan [EMAIL PROTECTED] wrote: yes you understood well that when the recordcount is not 0 it gives me a link or a list of links which it does properly but when it encounters a situation where it has no records the code must write a message over where the links are.. this it does not it only leaves it blank.. alex alex ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on the cfif code
Hmm I am not sure I fully understand...at the moment your code will output 'no risorce' in place of any links when there are no records returned. Is this what you want? This is what is happening for me On 10/27/06, alex poyaoan [EMAIL PROTECTED] wrote: yes that is what i want but what is happening now is it leaves the cfoutput blank when there's no record instead of displaying the message no risorse... i don't know what's wrong... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258225 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: help on the cfif code
Hmm I am a little stumped The only things that I can think of: - are you using Cfsetting enablecfoutput=yes anywhere ? try wrapping the text in cfoutput tags - although I don't think that it is this otherwise your links wouldn't output whent there are records - some kind of CSS overide ? seems unlikely though... have you viewed source to see if there are any clues in there? Is the page live where we could have a look at it? Maybe I am missing something obvious here but I can't see it ! On 10/27/06, alex poyaoan [EMAIL PROTECTED] wrote: i tried looking at it couldn't figure out and i'm not using cfsetting either you could check it out with this url http://208.112.4.154/docente.cfm?DOCENTE_ID=200 you could see links at the right box programmi the first two has list on the succeeding page on the box risorse and the third to the last links has not and with that it leaves the risorse box blank instead of writing the message i want.. thanks again ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on the cfif code
Alex Have you tested if the code is definitely dropping to the 'else' condition when there are no records being retrieved - try out putting the recordcount to make sure you know what you are getting back from the query or dumping the contents before the conditional block - on the else condition, try doing a dump or something (assuming you have a test/dev server) of the query results so that you know that you are dropping in to the else condition ok e.g. cfdump var=#risorse# See what happens there? i did what you told me cfdump var=risorse.recordcount and i placed it after the cfelse i don't know if it is right and it returns to me the number of records if there are or zero (0) if nothing thanks again On 10/27/06, alex poyaoan [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258235 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: help on the cfif code
If a CFQUERY returns no records it does not exist so there is no way to test for zero records as no result is produced. You need to tackle it along the lines of: cfif MyQuery.RecordCount Yes a result was made - ColdFusion has results ready to be handled. cfelse Na da. No response from the database (no records returned). /cfif okey the thing is it gives me a zero count if none appears... with the cfdump and as you see it is the same as the code above thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4