152 Posted Topics
 | [QUOTE=SimonSiew;1595910]is there a way to know the progress of the query to display a progress bar... [/QUOTE] No. Queries don't return partial progress. You'll only know when they're complete. [QUOTE=SimonSiew;1595910]or is there a way to cfflush the output so that it will begin populating while its still querying? [/QUOTE] Definitely … |
| | Did you verify the "selected" values actually exist in the query? Other than that the code looks okay except for the onChange. OnChange accepts javascript/actionscript. But it looks like you are passing in the selected value instead, which probably wouldn't work. |
| | [quote]I'm not doing actionscript, mind you, that's another headache I don't need.[/quote] Unfortunately once you start using flash forms, you can't avoid it for long. lol Not unless your forms are dead simple .. [quote]Yeah, I was never a fan of flash forms. They seem nice but I'd rather build … |
| | [QUOTE=teedoff;1429033]Got some good help at adobe forums...lol[/quote] ... among others ;-) Maybe it's lack of caffeine. But I've read the question twice and still don't understand what the data looks like. Could you give a sample of A) the values you're using (FORM.crossRefList, SESSION.crossRefList, productGroup) B) what the output SHOULD … |
| | Re: XMLSearch Issue Haven't figured out the magic string yet. But supposedly xpath gets ugly when quotes are involved. [url]http://kushalm.com/the-perils-of-xpath-expressions-specifically-escaping-quotes[/url] |
| | Don't know about your code. But Paolo's example shows a java.io.ByteArrayOutputStream as the fileContent. [code] <cfdump var="#response#"> [/code] A possible fix is explicitly convert it to UTF8 first. Then deserialize. [code] ... <!--- response is a java.io.ByteArrayOutputStream for some reason? convert it to UTF8 string ---> <cfset utf8Response = response.fileContent.toString("UTF8")> … |
| | I would answer, but looks like you're already being helped on the adobe forums :P |
| | The only way I know of is to use CFSAVECONTENT. But IIRC you have to escape CF tags. Otherwise, they're evaluated immediately instead of being treated as a plain string. <cfsavecontent variable="putme"> .. whatever code you want here. ...tags will be evaluated unless they're escaped </cfsavecontent> <!--- see what the … |
| | Re: struct issue [quote]I followed the code exactly[/quote] I hope not ... because that code is wrong :) Two things are messing it up 1) Assuming the \\ is not a typo. Get rid of them. 2) The function is StructInsert ... not StructureInsert But that function isn't used as much as it … |
| | [quote]I think the mail could not be sent before the directory is deleted.[/quote] No, not if you're using spooling. With spooling mail is sent via a separate thread and may be sent after you delete the file. If you read the docs on cfmail that's the expected behavior (see below). … |
 | You can't hide a query string. That's not how it's designed. You can however - encrypt query strings - use method=post instead of method=get, so variables are not sent through the query string - or store variables in the session scope instead .. But obfuscation isn't a substitute for good … |
| | Most of the time, replace() is more efficient. [I]Geez.. this thread's like 3 years old![/I] |
| | It's the right idea, but the logic breaks down for large strings like "123456789ABC66HYIGGasdfsdf ewqrdsfsdfsdfsd a111sdf134sa65d4asd4asd"; |
| | Post a small sample of what you've tried and what it's doing wrong/not doing. |
| | Your problem is the table design. You shouldn't store lists. That's why the query is so hard. Normalize the table and the query will be a simple join. Unique users and groups should each have a separate table. User Table: UserID (unique user ID) GroupsTable: GroupID (unique group ID) User … |
| | Any time parameter values contains special characters, you have to encode them ie Use UrlencodedFormat |
| | [quote] <cfif NOT ISDEFINED("form.Effective_Date")>[/quote] Text fields always exist. So IsDefined will do nothing. [quote]the "AND isDate(form.Effective_Date)" should return a true or false[/quote] It will, but the code's not using IsDate ;-) It's checking if the value is an empty string "". Trim() the field and use IsDate instead. |
| | That's too much for 1 page. Set it up as a scheduled task. Have the task pull 500 records. Process them, then have the task reschedule itself if there's more records to process. |
| | Not sure why it needs to be in an html page. Creating a small .cfm script that can be used from any page is the simplest. The other option is to configure the CF server to process .html pages (ie so any cfm code is executed). But that's a major … |
| | Personally that's too many popup messages for me ;-) But what you're describing is done with javascript, not CF. [url]http://www.w3schools.com/js/js_popup.asp[/url] You can incorporate the js into your form. You just have to tie it to the right event. Like in your form's OnSubmit() event. |
| | The error means there's some problem connecting to your database. The cause could be a lot of things. - has something changed with your db recently - which db type are you using? - does the error happen every time or just sporadically? |
| | [quote]Now the problem is whenever the user reregisters again the ids wont match[/quote] Registering is a one time event. It should never happen more than once. [quote]its really problematic because whenever the user forgets the password user is registering again such that there are duplicate entries.[/quote] The application shouldn't allow … |
| | Your question's a little confusing. What's your real goal in plain english, not code? To identify files by client, or somethin else ...? Also, what is a #Property# in this context? |
| | It'll only work for components. But something like the code below. See the docs for more details on cfinvoke. [url]http://livedocs.adobe.com/coldfusion/8/Tags_i_10.html[/url] [code] <cfinvoke component="cfcs.objectfactory" method="init" returnVariable="objFactory" argumentCollection="#settings#" > <cfset aplication.factory = objFactory> [/code] |
| | [QUOTE]One i use the single path link without database it works, but with database dynamic link, it wont play.[/QUOTE] You mean it works with a hard coded path but not when you use variables? Do a view source and look at the html generated. Compare it to the hard-coded-working version … |
| | [QUOTE=fiju;1424368]Because redirection occurs independent of the Yes/No values of that attribute[/QUOTE] The [URL="http://livedocs.adobe.com/coldfusion/8/Tags_j-l_04.html"]AddToken attribute[/URL] relates to client/session management. It has no affect on redirection. Only what's passed in the url. When addToken="yes", CF appends several client tokens (cfid, cftoken and possibly jsessionid) as URL parameters So this [code] <cflocation url="http://www.yoursite.com/path/to/products.cfm?productid=4" … |
| | Care to share the solution? I'm sure it will help others. |
| | Re: Coldfusion help Yeah, doesn't your app have a login page already? That's usually the point of having people register ... |
| | A windows shortcut? Just go to Desktop > right click > New > Shortcut and enter the url. |
| | What's wrong with this answer to your question? [url]http://forums.adobe.com/message/3295899#3295899[/url] |
| | [quote]<cfquery name="InsertUser" datasource="#request.dsn#"> BEGIN TRANSACTION SET NOCOUNT ON[/quote] Nothing to do with your error, but the TRANSACTION is in the wrong place. In it's current spot, it doesn't do anything because there's only 1 statement in that cfquery. Transactions apply to [b]multiple[/b] statements. I'd bet dollars to donuts, whoever wrote … |
| | [quote]ORDER BY "ItemOrder" ASC[/quote] Don't use quotes. If you do, your db will treat ItemOrder as a string, not a [I]column name[/I]. It's like saying [code]ORDER BY "IHaveNoIdeaWhyThisIsntWorkingThisIsNotARealColumn";[/code] It may execute ... but it won't sort anything. ;-) |
| | Sounds like a good job for a scheduled task. Just create a cfm page that queries your db for the desired records. Then send a cfmail to each one. Once the page is set up, create a scheduled task using the CF Administrator, or cfschedule. Schedule the task to run … |
| | The error message is pretty clear. The db can't find the object (ie Table) "Language". Run the query against directly against your db in MS SQL. Does it work? |
| | [QUOTE=ckkiran;1376424]Hi Can anyone help me how to point two cold fusion application to the same datasource.[/quote] Datasources are created at the CF server level. Just use the same datasource name in both applications. [QUOTE=ckkiran;1376424]Is it possible to have two differnet applications pointing to the same database?[/quote] Yes [QUOTE=ckkiran;1376424]If so how …  |
| | [code] Attribute validation error for CFMAIL. The value of the FROM attribute is invalid. The length of the string, 0 character(s), must be greater than or equal to 1 character(s). [/code] It's an error from cfmail. It's just saying the sender address cannot be empty. Where in your code are … |
 | From the little I've read there are some compatibility issues w/.net and soap. I haven't seen any success stories. Just suggestions to use xml instead. [url]http://stackoverflow.com/questions/1132536/consuming-apachesoapmap-complex-datatype-in-webservice-using-net[/url] |
| | CF9 has does have vfs. But image processing is time consuming. No avoiding it. It's usually better to just create thumbnails once and save them on disk. Resizing every time a user requests a page wastes a lot of resources. |
 | You mean store the file content in the db, not just the file path (ie "c:\path\myImage.gif")? While you can do it, it can drastically bloat your database. But if you really want to do it, here is an example. It's for Oracle but the overall process is the same for … |
| | The problem is dynamic sql. Save yourself some headaches and don't use dynamic sql. It's never as easy as it looks ;-) Plus it's hard to debug and is a big sql injection risk if done wrong ... But .. it doesn't look like you even need to return the … |
| | CF has a built in tag for that. You can use cfzip with a "source" directory [url]http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7695.html[/url] |
| | [quote]Here you go.[/quote] Not sure how that applies, since they said they're [B]not[/B] using cfauthenticate. Don't know the answer. I've only seen one post that's even remotely similar. [url]http://www.justskins.com/forums/screwed-up-with-cfauthenticate-36844.html[/url] |
| | I don't know about onRequestEnd.[COLOR="Red"]CFM[/COLOR]. But with Application.cfc the "targetPage" is passed into the onRequestEnd function. You could use string functions to determine if you should include the analytics. Maybe onRequestEnd.cfm has something similar? [url]http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7d42.html[/url] |
| | Playing around with the validator it doesn't seem to like the unclosed anchor <a> tags. It also didn't seem to like anchors that weren't nested inside some element like a <p> or <div> ...? This validated with 1 warning. [code] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" … |
| | ... you need to read the documentation ;-) [url]http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_c-d_25.html[/url] |
| | I'm too brain dead right now to explain it well. But most techniques use the MOD operator to determine when to create a new row. ie if the current index is divisible by 5, create a new row <cfif CurrentRow MOD 5 EQ 0> <!--- close the old row and … |
| | Unless there's a typo, you're not showing any text in the list ;-) ie <option>there should be something here </option> [quote]I even tried adding a size attribute.[/quote] That applies to vertical size. ie Display x items (or rows). To set the width, use CSS and the "width" attribute. Select lists … |
| | [quote]<cfif #URL.get#> or <cfif isDefined(URL.get)>[/quote] First and foremost, you have to make sure that variable is defined before using it. In the current code, you're checking the value 1st, then seeing if it's defined. That's probably why you're getting an error. Solution: your IsDefined() statement must be first. Second, IsDefined() … |
| | I don't know if CF9 supports the 2007 format out of the box (ie .accdb). [url]http://blog.crankybit.com/msaccess2007-and-cf8/[/url] I'd try using an .mdb file first. It should be simple. 1. Log into the CF Admin => Data & Services => Datasource 2. Add a DSN * Enter whatever name you want in … |
| | [quote]If it returns blank, it means they got to the page directly (user was not taken to it via a URL). [/quote] .. or that value is blocked by firewall s/w. |
The End.