- Strength to Increase Rep
- +7
- Strength to Decrease Rep
- -1
- Upvotes Received
- 11
- Posts with Upvotes
- 11
- Upvoting Members
- 6
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
152 Posted Topics
 | init() is just a standard convention most people adopt with components. The init() function initializes any variables needed by the component's functions. Then returns a reference to the current component. ie [code] Test.cfm <cfset myObj = createObject("component", "MyComponent").init(dsn="My DSN")> MyComponent.cfc <cfcomponent> <cffunction name="init" output="false" returntype="MyComponent"> <cfargument name="dsn" type="string"> <!--- initialize … |
| | Depends on what else the stack trace says. All we can tell from that is that something goes wrong when checking your jvm version. What's the rest of the trace? Check the logs if needed. |
 | Double the pound signs. ie Use ## instead of # [code] examples: <cfset value = "print ## sign"> <cfoutput>print ## symbol</cfoutput> [/code]  |
 | Re: CFTEXTAREA I doubt there is anything built in, but you could roll your own. Grab the textarea value, split it on some sort of word boundary (space, etcetera) and validate.  |
| | > Here's the code that's producing it. What you posted works perfectly w/CF10 and mySQL. Are you 100% positive that's the SQL you're using? Because a common cause of that error is forgetting the comma before the date mask ie DATE_FORMAT(Events.event_date "%W") instead of DATE_FORMAT(Events.event_date , "%W") |
| | > does this new id already exist in the array If you're looking for a magic function, there isn't one. You must loop through the array elements one by one. Pull out each structure, check it's ID. If it matches throw an error. It's as simple as that. |
| | > `decrypt(ToString(toBinary(strBase64Value)),"keycode")` If there are only 2 arguments, it's not AES. It defaults to a legacy algorithm called [CFMX_COMPAT](http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7c1c.html). Most CF apps don't use that anymore. I wouldn't bother trying to replicate it in c#. Better to decrypt and re-encrypt with whatever algorithm you plan to use in the new … |
| | Arrgh... the site ate my response. Anyway, that's a sql UPDATE. The basic syntax is: http://www.w3schools.com/SQl/sql_update.asp <cfquery ...> UPDATE TheTableName SET ImagePathColumnName = <cfqueryparam value="#variableWithPath#" cfsqltype="(your type here)"> WHERE PrimaryKeyColumn = <cfqueryparam value="#variableWithPrimaryKey#" cfsqltype="(your type here)"> </cfquery> If you need specifics, post your table structure and form code. |
| | Try a regular expression like `ReFind("[^\d]", form.theFieldName)` If the value's required, check the `LEN(...)` too. |
| | > 1. What are the circumstances you would use it. > 2. What are the advantages and disadvantages to using it over HTML? > 3. Is it compatible with CSS,Javascript, PHP, and MySQL? If you've used PHP (which I think you have) then you already know the answers to most … |
| | ColdFusion supports several persistent scopee. Take a look at the documentation for the `session` (per user) and `application` (entire app) scoopes. |
| | It doesn't make sense to use both in the same block. As jsmall26 said cflocation always wins because it runs first - on the server. The browser never even sees the javascript. The javascript belongs on the form page. It should execute before the form is submitted. Save the cflocation … |
 | HTML file inputs do not allow multiple file selection. AFAIK you need flash, etc. Take a look at a control like swfupload http://webdeveloperplus.com/jquery/multiple-file-upload-with-progress-bar-using-jquery/ |
| | > I need to loop over the first 5 arrays, then have another loop to output any remaining data greater than 5 If you elements, can't you just loop twice? Loop from 1-5, if there are enough elements <cfset firstLoopMax = Min(variables.albumEdit.albumCnt, 5)> <cfset lastShownIndex = 1> <cfloop from="1" to="#firstLoopMax#" … |
| | I'm not familiar with it, but the links here might help http://stackoverflow.com/questions/11175499/coldfusion-iis-pci-scan-servletexec-vunerability |
| | |
| | > And I get this error: > > Invalid parameter type. It's hard to follow all of that without seeing the values. Can you put together a small *concrete* example of the QoQ that's failing (with the values)? Btw, do you really have to use a QoQ? Couldn't you use … |
| | The 1st option should have a VALUE too, ie `<option value="0">Choose an order number</option>` But other than that it looks ok. 1) Is that the exact code used? 2) Maybe one of the query values is causing a problem. Do some debugging and ump the query values. Can you post … |
| | On what line does the error occur? I don't know the app, so I'm guessing based on what I see. "dtRan" appears to be the name of a column in a query. There are 2 queries in the code (cfspExportInfo and cfspExport). The error suggests one of them does not … |
| | > I am having problems with pagination using cfloop and the grouping of cfoutput Trying to combine cfloop start/endRow and a grouped output is just asking for pain. I honestly doubt it's possible. You either need to do *real* pagination ie only return x records in the query or drop … |
 | [QUOTE=;][/QUOTE] {Reaches for can of troll-spammer-be-gone} |
| | [QUOTE=;][/QUOTE] [quote]your code is very easy to hack and if you're using similar formed queries, I can do some dangerous things.[/quote] Sad there are still apps out there with this kind of unprotected code .. Makes you want to ask for the company web developer's credentials before doing business online. |
| | I don't see a stray characters. If it only happens with .cfm files, check your Application.cfm/cfc files. It runs every time you request a .cfm page. So it might be the culprit. |
| | [quote]That won't work. <cflocation> only works with relative paths[/quote] cflocation can redirect to an absolute url ie http://www.somesite.com, so I don't think that's the problem. |
| | [QUOTE=;][/QUOTE] Unfortunately I don't know how to decode UTF16. If it were a regular UTF8 string - or the values always had 2 leading zeroes - you could decode it like any 2 char hex string. Loop and grab every 4 characters. Use inputBaseN to get the ascii code, and … |
| | [QUOTE=;][/QUOTE] We need to see the INSERT code to hazard a guess. |
| | [QUOTE=;][/QUOTE] Sorry you're asking in the wrong zone. This is ColdFusion. ASP.net is next door ;-) [url]http://www.daniweb.com/web-development/aspnet/18[/url] |
| | Re: CFC: Bind issue [QUOTE=;][/QUOTE] [quote]My problem is when I try to select a Year, the models dont change based on that selection[/quote] If that's the desired result, your binds are backward. Year is bound to model. So when the year list changes when a model is selected, not the other way around. |
| | |
| | I haven't done anything like this. So I can't say whether there's a better option. But it certainly sounds doable from a technical standpoint. It's just a series of cfhttp posts and db queries on your end. What issues are you seeing? |
| | [QUOTE=;][/QUOTE] [quote]its not even a variable with time in it. ... <cfset ET = timeformat(EndTime, 'H')> [/quote] Then why are you using timeFormat on it? :) If EndTime is null, its probably returning an empty string, hence the error when you try and perform subtraction. Make sure it's a number … |
| | [QUOTE=;][/QUOTE] [quote] 1) where date discontinued is between the start and end date 2) If the start date is NEQ to the end date I need to find if there is another entry with a discontinued date 3) if not then output the entries that have a NULL endate. [/quote] … |
| | [QUOTE=;][/QUOTE] Define "not working". What's it doing vs what you want it to do. What db type? |
| | [QUOTE=;][/QUOTE] [quote]The one on server A needs to pass some info to the one on server B.[/quote] How much information? How often? [quote]dbname.db.0000000.thisdbhost.com[/quote] What are you pointing to that location? Connecting to a remote database MAY be possible if both your firewalls and permissions allow. They often don't for obvious … |
| | [quote]31/8/2011[/quote] Also you can't use dd/mm/yyyy format. The standard functions expect values to be in U.S. date format ie mm/dd/yyyy. If your CF server is running under a locale where the standard is dd/mm/yyyy (like in England) then use the LS functions to parse the value first. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_p-q_18.html [code] <cfqueryparam … |
| | Could store the value in a hidden form field or non-visible html element (read about the "display" attribute). All depends on why you need to do this .. http://www.w3schools.com/cssref/pr_class_display.asp |
| | [QUOTE=;][/QUOTE] Can't help you with jquery. But why not just use CF's built in autosuggest? Are you running CF8 or higher? [url]http://tutorial7.learncf.com/[/url] |
| | Re: cfselect binding [QUOTE=;][/QUOTE] Sadly it's strictly DIY unless you're running CF9 [url]http://www.dansshorts.com/post/cfselect-binding-and-selectedvalues[/url] [url]http://stevenksavage.com/index.php/archives/14[/url] |
| | [QUOTE=;][/QUOTE] Print an order [i]where[/i]? If you mean server side printing, take a look at <cfprint>. If you mean client side, web pages can't access a user's printer directly for security reasons. The best you can do is display a prompt as shown in the prev link. |
| | Re: Form values [QUOTE=;][/QUOTE] [quote]It shows no message just says page not found[/quote] If you're using IE, it's probably a badly worded error message. Turn off it's friendly error messages or you won't be able to view the real error [url]http://malektips.com/internet-explorer-8-disable-friendly-error-messages.html[/url] [quote]but when I remove the between clause it seems to work[/quote] That's … |
| | [quote]Is there a way, where i can get two values from a option tag[/quote] No. If there isn't a unique key you can use instead, you could concatenate the values into a single string. Pick a delimiter that doesn't occur in the data. Then use list functions to separate the … |
| | [quote]So how can i know which button was clicked.[/quote] Only the button clicked will exist on the action page. If all 4 buttons share the same name, use the button value ie #form.submitButton# ie [code] <cfparam name="form.submitButton" default=""> <!--- display selection ---> <cfdump var="#form#"> <form method="post"> <input type="submit" name="submitButton" value="add" … |
| | [QUOTE=Nazmul Haque;1636140]I got strange result from the command.[/QUOTE] What do you mean by "strange"? What was the actual error message? [QUOTE=Nazmul Haque;1636140]web application. I used MS Access as back-end database.[/quote] Honestly MS SQL would be a better choice. MS Access was designed for individuals to use on their desktops, not … |
| | [QUOTE=;][/QUOTE] It's not going to be nearly that complicated. What's your query used for in plain english? ie Is it a reservation system and you're trying to find out what's booked? [quote]Neither of these seemed to work [/quote] Can you give an an example of all 3 dates and what … |
| | [quote]When I do this in MSAccess sql view it works but doesn't work on cfm page. [/quote] (Yeah, that's special "Access" syntax. It may work with some drivers, or it may not.) But the correct way to pass dates in cfquery is with cfqueryparam. [code] WHERE Stuff.RegDate = <cfqueryparam value="5/1/2004" … |
| | [quote]Yes, I've tried the cfdocument tag, and it is creating pdf forms for me, but I'd like to get data from a database to populate the pdf form based on the user id that is passed in the url. [/quote] Huh? ;) cfdocument doesn't create or populate forms. But you … |
| | Huh? In one breadth you preach protection against sql injection, and in the next you recommend a function that encourages sql injection ;-) - [I]DO[/I] use cfqueryparam for sql injection protection - [B]DO NOT[/B] use perservesinglequotes, it risks sql injection [quote]If you have data that has single of double quotes …  |
| | This has nothing to do with CF. It is a pure SQL question ;) [quote]AND MoveOutDate = 'NULL'[/quote] NULL isn't a string. It is a [URL="http://www.w3schools.com/SQl/sql_null_values.asp"]special system value[/URL]. You can't use equals "=" either. To find nulls you must use [code] WHERE ColumnName IS NULL [/code] |
| | I haven't tested the code. But assuming "select" really is the problem, other options are to a) hide the column(display=false) or b) duplicate the value in your query and hide one version, and show the other. It doesn't matter if the visible version is editable, because you'll just ignore it … |
| | It's caused by the default YUI settings (javascript lib). It only returns stuff that [i]start with[/i] whatever you typed. See the bottom comments for how to fix it. [url]http://www.coldfusionjedi.com/index.cfm/2007/7/23/A-Gotcha-with-Auto-Suggestions-in-ColdFusion-8[/url] |
The End.