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

Re: problem with ajax on cflayout form submission

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

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

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

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 /

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 /

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

Re: cfselect display problem

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

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

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

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

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

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

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

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...

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

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

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

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

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

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

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

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

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

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

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;

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

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

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

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

Re: problem displaying event if it ends on the succeeding month

-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

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

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

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

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

Re: problem displaying event if it ends on the succeeding month

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

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

Re: problem displaying event if it ends on the succeeding month

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

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

Re: problem with cfif conditions on dates

://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

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

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

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

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

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

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

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

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

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

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 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 :

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 :

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

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

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

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

Re: problem with form field undefined

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

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

Re: problem with listgetat

=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

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)

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

Re: help on variable undefined on a url.variable

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

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

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

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

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

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.

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

Re: Error Executing Database Query

) 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

Re: Error Executing Database Query

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

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

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

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

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

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

Re: problem with a file extension

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

Re: problem with a file extension

, 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

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

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

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

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

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

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

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

Re: help on displaying 1 photo daily

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

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

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

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

Re: help on cfquery and 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

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

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

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

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

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

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

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

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

Re: help on the cfif code

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

Re: help on the cfif code

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

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

  1   2   >