Adobe Community : All Content - All Communities

Incorrect string value

forums_noreply@adobe.com — Mon, 12 May 2014 13:25:46 GMT

Hi - we've just upgraded from cf8 to cf9 and are getting a fair few of these errors - "Error Executing Database Query. Incorrect string value: '\xE2\x80\x8BWe ...' for column" as we try to insert a row in the db.

The query is inserting the following string "We are seeking a" - nothing innocuous in the text and certainly no instance of this string '\xE2\x80\x8B' (despite what the error message says).

Has anyone else run into this, any ideas what's going on?

Thanks very much for any help you can offer as I'm completely stuck.

Thank you.

Kind regards,

Nick

cfform autosuggest pass 2 values (locationname and locationid)

forums_noreply@adobe.com — Tue, 24 Jun 2014 11:29:03 GMT

Hi chaps,

I've decided it's about time I started using cfform (3 mins in and I've already hit my first stumbling block!)

I want to have an autosuggest text input for users to choose a city. In my db I have locationnames and locationids.

locationid | locationname

----------------------------------------

1 London

2 New York

3 Paris

etc

The user will start to type the locationame - I want autosuggest to show locationanames that match, but when they submit the form I actually want the locationid to be passed..

How on earth do I do this with cfform?

Thanks very much for any help you can offer.

Nick

bug in cfadmin > scheduled tasks? Updating a task breaks the password even though I didn't touch the password field

forums_noreply@adobe.com — Mon, 16 Jun 2014 12:26:47 GMT

1. create a task which uses the username password facility (eg run a page that requires authentication to reach)

2. save the task (check it runs ok)

3. go back in and change something (eg change when the task is to run) but don't touch the username/password bit

4. save the task

the task will now fail to run correctly as the password will now be incorrect (even through it was correct before and hasn't been touched).

Is anyone else experiencing this (CF9) - I do wonder if it's my browser messing with the password field?

How to turn this Java into something I can use in CF?

forums_noreply@adobe.com — Mon, 09 Jun 2014 14:17:55 GMT

Hi - Following on from a recent post about how to strip our special characters from a string before insertion to the db I have found this Java code - my question is, how can I turn this into something I can use with CF? I think I need to use the cfscipt tag but that's right on the boundaries of my knowledge base.. If anyone could please help I'd be ever so grateful - thank you!

package net.htmlescape;

/**

* HtmlEscape in Java, which is compatible with utf-8

* @author Ulrich Jensen, http://www.htmlescape.net

* Feel free to get inspired, use or steal this code and use it in your

* own projects.

* License:

* You have the right to use this code in your own project or publish it

* on your own website.

* If you are going to use this code, please include the author lines.

* Use this code at your own risk. The author does not warrent or assume any

* legal liability or responsibility for the accuracy, completeness or usefullness of

* this program code.

public class HtmlEscape {

private static char[] hex={'0','1','2','3','4','5','6','7','8','9','a','b','c','d','e','f'};

/**

* Method for html escaping a String, for use in a textarea

* @param original The String to escape

* @return The escaped String

public static String escapeTextArea(String original)

{

return escapeSpecial(escapeTags(original));

}

/**

* Normal escape function, for Html escaping Strings

* @param original The original String

* @return The escape String

public static String escape(String original)

{

return escapeSpecial(escapeBr(escapeTags(original)));

}

public static String escapeTags(String original)

{

if(original==null) return "";

StringBuffer out=new StringBuffer("");

char[] chars=original.toCharArray();

for(int i=0;i<chars.length;i++)

{

boolean found=true;

switch(chars[i])

{

case 60:out.append("<"); break; //<

case 62:out.append(">"); break; //>

case 34:out.append("""); break; //"

default:found=false;break;

}

if(!found) out.append(chars[i]);

}

return out.toString();

}

public static String escapeBr(String original)

{

if(original==null) return "";

StringBuffer out=new StringBuffer("");

char[] chars=original.toCharArray();

for(int i=0;i<chars.length;i++)

{

boolean found=true;

switch(chars[i])

{

case '\n': out.append("<br/>"); break; //newline

case '\r': break;

default:found=false;break;

}

if(!found) out.append(chars[i]);

}

return out.toString();

}

public static String escapeSpecial(String original)

{

if(original==null) return "";

StringBuffer out=new StringBuffer("");

char[] chars=original.toCharArray();

for(int i=0;i<chars.length;i++)

{

boolean found=true;

switch(chars[i]) {

case 38:out.append("&"); break; //&

case 198:out.append("Æ"); break; //Æ

case 193:out.append("Á"); break; //Á

case 194:out.append("Â"); break; //Â

case 192:out.append("À"); break; //À

case 197:out.append("Å"); break; //Å

case 195:out.append("Ã"); break; //Ã

case 196:out.append("Ä"); break; //Ä

case 199:out.append("Ç"); break; //Ç

case 208:out.append("Ð"); break; //Ð

case 201:out.append("É"); break; //É

case 202:out.append("Ê"); break; //Ê

case 200:out.append("È"); break; //È

case 203:out.append("Ë"); break; //Ë

case 205:out.append("Í"); break; //Í

case 206:out.append("Î"); break; //Î

case 204:out.append("Ì"); break; //Ì

case 207:out.append("Ï"); break; //Ï

case 209:out.append("Ñ"); break; //Ñ

case 211:out.append("Ó"); break; //Ó

case 212:out.append("Ô"); break; //Ô

case 210:out.append("Ò"); break; //Ò

case 216:out.append("Ø"); break; //Ø

case 213:out.append("Õ"); break; //Õ

case 214:out.append("Ö"); break; //Ö

case 222:out.append("Þ"); break; //Þ

case 218:out.append("Ú"); break; //Ú

case 219:out.append("Û"); break; //Û

case 217:out.append("Ù"); break; //Ù

case 220:out.append("Ü"); break; //Ü

case 221:out.append("Ý"); break; //Ý

case 225:out.append("á"); break; //á

case 226:out.append("â"); break; //â

case 230:out.append("æ"); break; //æ

case 224:out.append("à"); break; //à

case 229:out.append("å"); break; //å

case 227:out.append("ã"); break; //ã

case 228:out.append("ä"); break; //ä

case 231:out.append("ç"); break; //ç

case 233:out.append("é"); break; //é

case 234:out.append("ê"); break; //ê

case 232:out.append("è"); break; //è

case 240:out.append("ð"); break; //ð

case 235:out.append("ë"); break; //ë

case 237:out.append("í"); break; //í

case 238:out.append("î"); break; //î

case 236:out.append("ì"); break; //ì

case 239:out.append("ï"); break; //ï

case 241:out.append("ñ"); break; //ñ

case 243:out.append("ó"); break; //ó

case 244:out.append("ô"); break; //ô

case 242:out.append("ò"); break; //ò

case 248:out.append("ø"); break; //ø

case 245:out.append("õ"); break; //õ

case 246:out.append("ö"); break; //ö

case 223:out.append("ß"); break; //ß

case 254:out.append("þ"); break; //þ

case 250:out.append("ú"); break; //ú

case 251:out.append("û"); break; //û

case 249:out.append("ù"); break; //ù

case 252:out.append("ü"); break; //ü

case 253:out.append("ý"); break; //ý

case 255:out.append("ÿ"); break; //ÿ

case 162:out.append("¢"); break; //¢

default:

found=false;

break;

}

if(!found)

{

if(chars[i]>127) {

char c=chars[i];

int a4=c%16;

c=(char) (c/16);

int a3=c%16;

c=(char) (c/16);

int a2=c%16;

c=(char) (c/16);

int a1=c%16;

out.append("&#x"+hex[a1]+hex[a2]+hex[a3]+hex[a4]+";");

}

else

{

out.append(chars[i]);

}

return out.toString();

}

coldfusion 11 I've installed it - how do I get to cfadmin?

forums_noreply@adobe.com — Tue, 17 Jun 2014 20:14:44 GMT

Hi, I've installed CF11 on Mac Mavericks.

What's the url to cfadmin?

http://127.0.0.1:8500/CFIDE/administrator/index.cfm doesnt work

and neither does http://127.0.0.1:8600/CFIDE/administrator/index.cfm

Any ideas?

Thanks

cant update CF (Error occurred while installing the update: Failed Signature verification)

forums_noreply@adobe.com — Sat, 14 Jun 2014 09:44:47 GMT

Hi I'm suffering with this issue Bug#3506758 - MySQL 5.6 Unable to Execute Queries

and therefore am trying to update cf 10 to version 13 (current version is 8) however I get 'Error occurred while installing the update: Failed Signature verification'

I'm running Mavericks on Mac.

Can anyone point me to a step by step way to resovle this please (I'm new to Macs and am a cf coder but alas dont have any experience in server admin).

Thanks very much indeed.

Nick

How to get 'name' from 'name@domain.com' using cf reg ex?

forums_noreply@adobe.com — Mon, 26 May 2014 10:29:50 GMT

Hi everyone.

I'm trying to get 'name' from 'name@domain.com' using cf reg ex.

I've got this so far #rereplace('temp.emailaddress','[^@]+','')#

which is giving me @domain.com - but I want the first part, can anyone point me in the right direction please?

Thanks ever so much.

Nick

CF liscence - most cost effective way?

forums_noreply@adobe.com — Mon, 22 Jul 2013 09:38:08 GMT

Hi there - currently we are hosted at Firstserv in the uk but we're considering leasing our own dedicated server from a non coldfusion company (like fasthosts for example) and then installing cf on that box.

What sort of cf liscence would we need and what's the most cost effective way to buy it?

Currently we use CF8 and are more than happy with it, can one still buy CF8 liscences? or CF9 even?

I've seen some pretty high prices (like in the thousands) but I'm hoping they are if you want to host third parties websites.. if you are only hosting your own sites presumably it's not so expensive?

Any help very gratefully received.

TIA

Nick

cfquery datasource="mydb" result="result" - used to work but now gives "Variable RESULT is undefined

forums_noreply@adobe.com — Mon, 11 Jul 2011 09:56:53 GMT

Hi there

I have a query that uses the "result" attribute

it's been working fine for years - now all of a sudden it stops working (we haven't changed a thing)

Now we get this error "Variable RESULT is undefined"

This has happend to me a few times now - each time the same.. a query using the "result" attribute works fine for ages then out of the blue it stops.

I once saw a thread where others were having the same problem and at the time it was unresolved. I can't find that thread now (wasn't in adobe forums) so am hoping someone out there can thrown some light on this one?

Thanks chaps.

Nick

Getting started with Ajax - how do I query the db without 'submitting' the page?

forums_noreply@adobe.com — Thu, 05 Aug 2010 07:05:33 GMT

Hi guys,

I'm building a simple 'power point presentation' - basically a cf page which will display a large jpg [a slide]) every n seconds I want the page to query the db to ask if it needs to change the jpg and if so which jpg should it now show. In this way we can control the presentation by updating the database on the fly.

So I think I will acheive this as follows:

1. a 'display' page that contains javascript that fires every n seconds

2. that js to somehow pass 2 variables (GET?) to an action page (ie user id and an authentication var)

3. the action page will the query the db (using the vars passed in step 2)

4. the action page returns a result (path to jpg to display) which somehow(?!) is passed back to the display page

5. the display page then swaps the jpg it is showing for the one passed back to it in step 4

6. ideally the display page then also passes another 2 variables to the action page letting us know it has received the update and changed the image accordingly

I'm fine with all the html and cfm stuff - where I am stuck is the js bits, I've had a good look through google and don't seem to be making any progress so if anyone could please point me in the right direction I'd be ever so grateful.

Any snippets / advice very gratefully received

TIA

Nick

cf throws "RECRUITER is undefined in URL" error yet then reports query string =type=byrecruiter&recruiter=271

forums_noreply@adobe.com — Thu, 05 Mar 2009 12:51:19 GMT

hi guys

i keep getting this error (when certain spiders crawl my site)

Diagnostics Element RECRUITER is undefined in URL. <br>The error occurred on line 123.
Message Element RECRUITER is undefined in URL.
QueryString type=byrecruiter&recruiter=271

i dont get it

the error says url.recruiter isnt defined then clearly reports that the querystring contains that very variable??

the only thing that i can imagine is that if the query string was "type=byrecruiter&recruiter=271" instead of "type=byrecruiter&recruiter=271" (ie. '&' not '&') then presumably there'd be no way that could throw an error

personally when i code urls into links etc i use '&' not & but i *think* the spiders that are generating the errors must be changing & into & (which doesnt seem unreasonable to me if they want to do that) yet this seems to be throwing cf off

any thoughts would be very gratefully received - thanks guys

TIA

Nick

using <cferror and appErrorHandler.cfm but only some types of errors caught in this way

forums_noreply@adobe.com — Thu, 12 Mar 2009 21:07:17 GMT

hi there

i dont want users to ever see the default error message

i have put <cferror type="request" exception="any" template="/errorDocs/appErrorHandler.cfm" /> in application.cfm

and appErrorHandler.cfm is a nice simple page which i am 99.99% sure can not ever have any errors in it.

alas sometimes users get my error page, other times they get the default cf one

i have carried out some testing and found that if i create an error such as

<cfif myvars.this_var_doesnt_exist eq 1>hello</cfif> [ie referencing a non-existant variable] ------- this would result in the user getting my error page as desired

however this error:

<cfif myvars.this_var_doesnt_exist eq 1>hello [ie not closing a <cfif> statement with a </cfif> tag] ------- then this still results in the default cf error page being shown

i have also tried to cover all bases by putting this in application.cfm

<cferror type="validation" exception="any" template="/errorDocs/appErrorHandler.cfm" />
<cferror type="request" exception="any" template="/errorDocs/appErrorHandler.cfm" />
<cferror type="exception" exception="any" template="/errorDocs/appErrorHandler.cfm" />

but it still dont work

any thoughts anyone?

TIA

Nick

cf to google adwords api?

forums_noreply@adobe.com — Sun, 01 Mar 2009 18:48:12 GMT

hi guys

i remember reading a while ago that it might be possible to get cf to talk to google adwords.

has anyone had any experience of doing this?

any pointers that you wish you'd been told about before you got started in this area?

thanks very much indeed for any info you deem it relevant to point out

TIA

Nick

CF function to parse/escape bad characters in xml for rss feed

forums_noreply@adobe.com — Fri, 20 Feb 2009 09:30:08 GMT

hi guys

im creating my first rss feed and i believe one needs to remove/escape certain characters from the xml

is that right?

im pressuming theres a cffunction for this handful of promising sounding ones i found all caused errors which i didnt understand so i thought i'd ask for a pointer in the right direction

sorry if this is silly question

TIA

do i need a UNION / or a JOIN or something else?

forums_noreply@adobe.com — Thu, 19 Feb 2009 21:48:38 GMT

i have a table which contains property listings

each property listing can either be a "standard" or "premium" depending on how much the advertiser has paid to display their advert

this data is stored in the "advert_type" column (advert_type =1 means advert is premium / advert_type = 0 means advert is standard)

when displayed the premium listings appear at the top of the list

currently we handle this simply by "order by advert_type, date_advert_placed" - nice and simple

however i want to make the premium listings appear twice (once at the top and once where they would naturally appear in the list if they were "standard", so I'm thinking I need to do 2 queries and then join them somehow

the important thing is this query gets hit hard and the table involved is big so I'm looking for efficiency here

im thinking my 2 queries would be something like

<cfquery datasource="db" name="premium_listing_only" >
select *
from tbl_listings
where advert_type = 1
</cfquery>

<cfquery datasource="db" name="all_listings" >
select *
from tbl_listings
where advert_type = 0 or advert_type = 1
</cfquery>

I could outout the first query and then the second, but of course I need to do some record set paging so I'm really looking for one query..

All suggestions gratefully received

TIA

putting a '£' symbol in a cfmail subject line

forums_noreply@adobe.com — Fri, 09 Jan 2009 10:45:48 GMT

hi guys

i have this:

<cfif mailtosend eq 1>
<cfset mailsubject = 'buy this for £10' >
<cfelseif mailtosend eq 2>
<cfset mailsubject = 'buy something else for £20'>
</cfif>

<cfmail to="blah@blah.com" from="blah@blah.com" subject="#mailsubject #" >
message
</cfmail>

(my subject lines arent really as spammy as this -but you get my point)

I need a pound £ symbol in the subject line but when i do a test mailing the pound sign converts to a funny symbol

ive tried using the &pound ; and &#163 ; but the former didnt work either and the latter caused a cf error due to the #

i tried changing the # to ## but that didnt work either

im sure im missing something somewhere

perhaps i need a function like cfencodee_as_subject_line('buy this for £10') but i cant find anything in google

any help would be very grateful received

thanks very much

scanning uploaded documements for viruses in CF

forums_noreply@adobe.com — Thu, 04 Dec 2008 18:18:53 GMT

hi guys

currently everytime a user uploads a document to our application it is emailed to one of our pc's in the office where we scan it for viruses and then (assuming it's ok) we then make an entry in the application's database to state that that user's document is ok so they can do stuff with it

bit of a long way round, so i'm hoping to implement something that is all based on the server

eg:

1 user uploads document to server
2 cf reads filename of document
3.cf then passes the filename/path to some antivirus tool installed on the server
4.this antivirus tool scans just that document
5.the antivirus tool then feedsback to cf
6.coldfusion takes necessary action:
-if document ok, mark as such in db
-if document bad, cf deletes it and warns user they may have a virus (and warns us they may be a hacker!)

i can do all of this easy peasy, except steps 3,4 and 5

does anyone have any advice for me?

my isp has Dr.Web® anti-virus for Windows installed on our server so it'd be good to use that if poss - anyone know how cf can talk to it?

if not does anyone have any other suggestions?

thanks very much in advance

kind regards

Nick

what's the MYSQL equivalent of WHERE len(column-in-db) gt 2

forums_noreply@adobe.com — Sun, 28 Sep 2008 08:31:33 GMT

hi guys

hopefully this is a simple question - im afraid i cant find anything in google

i want to select based on the length [len()] of a value

eg:

select *
from mytable
where len(column-in-table) gt 4

so my query would select 'apple' and 'orange' but would not get 'pea'

thanks very much indeed

kind regards

Nick

how to handle weird characters in form fields (like bullet points from Word docs)

forums_noreply@adobe.com — Wed, 03 Sep 2008 19:25:45 GMT

hi there

lots of my users copy and paste from MS Word documents into a text area

my app takes that form.textarea data and inserts it in a MYSQL db.

when we output that cell from the db, we often find there are ? [question marks] where there once were special characters in the Word doc text.

it seems that bullet points in word docs are the worst offenders.

each time i spot a new one i try to find out the chr() number for it and make a substitiution before the text is stored in the db, but its a bit hit and miss (relies on me spotting it) and its v time consuming

ive tried using functions safetext and demoronize - but they dont seem to do what i need

im sure im not the first person to run into this - any suggestions anyone?

thanks very much indeed for any help you can give.

kind regards

Nick

can you amend Word docs using CF?

forums_noreply@adobe.com — Tue, 05 Aug 2008 11:40:49 GMT

hi there,

i have a load of word documents (.doc / docx) on my server

i want to do the following:

1 read each document to find any instances of an email address contained within (will use Regex for that i guess)
2 replace each email address with "---there was an email address here and the server has removed it---"
3 save the new (amended) word document

Does CF 8 have any new clevernesses to help me out here?

I suspect I may have to read the contents of the word doc into memory, make my changes there and then create a new word doc (using cfdocument?) with my amended content that is now in memory.

If anyone has any comments / suggestions to help me avoid any dead-ends i'd be ever so grateful.

Thanks very much indeed.

any suggestions on how to update production database when dev db has had tables added etc

forums_noreply@adobe.com — Mon, 07 Jul 2008 12:58:27 GMT

hi guys, i've been really struggling with this problem and i wondered if anyone has any clever solutions.

we have a production db (mysql) and a development db (also mysql).

the production db gets lots of rows added to it throughout the course of the day

i am working on the dev db and from time to time need to introduce new columns and new tables on the dev db.

the problems come when it's time to update the production db (by adding the new columns / tables etc) - although i backup the production db and download it and work from that copy. while im working on it new rows are being added to the production db so i cant just upload my amended copy from dev db to prodution (as i would loose those rows).

what i tend to do is to use php myadmin to 're build' the new tables etc on the production db - but it's a real pain.

i wonder if there is a clever 'compare the structure of these 2 databases and update 1 in terms of tables/colum structure whilst keeping the data intact' facility in mysql?

or perhaps i can ask mysql to generate the necessary code that i could then run on the production db to have it amend itself accordingly?

hope this makes sense! what do you guys do?

are application variables 'user specific'?

forums_noreply@adobe.com — Thu, 03 Jul 2008 12:49:16 GMT

hi - i've got a feeling i may have done something stupid.

we have several domains all pointing to one application.

in application we look at the cgi.http_host to work out which site the domain the user is expecting and then serve up customised content accordingly.

only this is i've set put the customised content in application scoped vars - is that a bad move?

eg. in application.cfm i have:

<cfif cgi.http_host eq 'www.redredred.com' >
<cfset application.message= "welcome - we love the colour red" >
<cfelseif cgi.http_host eq 'www.blueblueblue.com' >
<cfset application.message= "welcome - to our site where we love blue" >
<cfelse>
<cfset application.message= "welcome to our site (we love all colours)" >
</cfif>

then in the index.cfm:

<cfoutput>#application.message#</cfouput>

is there a chance that by doing this someone who has visited www.redredred.com will get a message about blue?

<cflocation to a file located 'above' the httpdocs folder

forums_noreply@adobe.com — Tue, 24 Jun 2008 18:45:59 GMT

hi guys, i got a tricky one here...

users can upload word documents (.doc) to my server (using cffile).

the idea is to only allow certain users access to those documents, therefore i am thinking that storing them 'above' the httpdocs folder is probably a wise move (that way no one can get to them using httpaccess, right?)

i can write the files to my desired location using <cffile action="copy"... just fine

the problem arrises in giving (the authorised) users access to those documents.

i want them to be able to download those documents via their browser and had planned to do so using <cflocation url="#absoloute-path-to-required-document-on-server.doc#" >

it seems this works fine if the file is within the httpdocs folder, but not if it's above it..

does anyone have any suggestions?

i'd be very grateful of any input whatsoever (if you think i'm tackling this the wrong way for example, i won't be offended :)

thanks very much indeed.

kind regards

Nick

client side spell checker - what do you guys use?

forums_noreply@adobe.com — Sun, 22 Jun 2008 20:18:48 GMT

hi guys, i want to add a simple client side spell checker to my cf site

does cf8 have anything that can handle this in it's Ajax capabilities does anyone know, if not does anyone have any Javascript solutions to recommend?

thanks very much indeed

Kind regards

Nick

taking screengrabs of sites in CF

forums_noreply@adobe.com — Thu, 24 Apr 2008 15:24:37 GMT

hi - here's a good one for you..

we want to be able to take a screengrab of a site's index page and save it as jpg (we have a list of 1000 sites we want to do this for)

i'm thinking that it can probably be done using cfhttp and then outputting the obtainted html within cfdocument tags to create a jpg of the page

then we could use cfimage to reduce the size of that resulting image to 400px wide

before i spend the next 10-20 hours barking up the wrong tree with this; does anyone have any comments / suggestions / heads up's to make?

anyone done this before, ran into any problems? got an easier route to suggest?

thanks very much indeed.

CF Ajax - how to make a small form 'pop up' over the existing content

forums_noreply@adobe.com — Fri, 25 Apr 2008 16:56:58 GMT

hi. i have a standard html form with quite a few elements (selects, radio buttons, input fields, text areas etc)

some users will need the ability to supply additional data but i only want the fields for this additional data to appear upon request (to keep the form clean looking for the majority of users)

i want to make it when users click on an "add more detail" button then the screen goes 'greyed out' and a new form appears roughly 350px x 350px centred on their screens. ive seen this done quite a lot recently and was just about to google javascript tutorials to get started, then it occured to me i may be able to utilise cf8's ajax tags to achieve this (which would be handy as i really struggle with anything other than v basic javascript)

my requirements are:

1 button (or link) in my standard form that launches the 'more detail' form in a ?layer? over the top of the existing content
2 when this happens the existing content is 'greyed out' preventing uses from interracting with it until they either complete this new form (or click the close button in that new form)
3 this form is to contain 2 text inputs and a submit button
4 i want to pass the data from this form back to the original form when it is submitted (temporarily storing the data in hidden fields within the original form) and will then ultimately pass this back to the server when the original form is submitted

does anyone know if cfajax can help me with this (i dont need the asynchronous server interaction stuff ajax offers only the javascript to make my form pop up etc)

if not does anyone know what this behaviour is commonly termed so i can google for it

thanks very much indeed for any help

cheers

Nick

getting started with cfc's - how do i pass a variable in?

forums_noreply@adobe.com — Sat, 19 Apr 2008 10:44:59 GMT

hi - i'm trying to write my first cfc. i want it to get some data from the database but cant seem to get it to accept a variable that exists in the page i'm calling the cfc from (although oddly it seems to be able to make use of form variables that exists in that page - i can give more info on that weirdness if you want it)

i have this: (code attached)

but get this error:

"Element LOCATIONID is undefined in FORCFC."

what's that all about - i just set it on the line before i invoked the cfc - didn't i?

thanks in advance

can you not set a variable that's in the same scope as a query structure

forums_noreply@adobe.com — Tue, 22 Apr 2008 13:57:17 GMT

ok so i got a query

<cfquery datasource="mydb" name="note_this_name" >
select columnone, columntwo
from tbl_mytable
</cfquery>

i then do this

<cfset note_this_name.not_a_column_name = "i_will_never_be_able_to_use_this_variable" >

then i do this

<cfoutput>#note_this_name.not_a_column_name#</cfoutput>

and i get this error " Element not_a_column_name is undefined in note_this_name"

How on earth can this be? am i going mad?

storing whitespace in db that comes from textarea

forums_noreply@adobe.com — Wed, 16 Apr 2008 10:12:39 GMT

hi guys,

i am taking user input from a textarea in a form and saving that in my db.

as we all know when one does that the whitespace is sent from the browser to the server but from there on it can get 'lost'

in a previous application i built i think i did something like this -- replace(form.text_from_textares,chr(10),"<br />,"all") -- and then stuck that in the db

but to be fair i never really understood exactly what chr(10) represented and if that was infaliable (ie did it catch all 'white space'?)

anyway - i dont think this is ideal as if one then want to search for a string that is broken up with a carridge return or similar your search code would be unlikely to find it as you've gone and stuck a BR tag in the middle of it.

what is considered best practice here?

PS if anyone is able to explain the differences between CR and LF and what they're all about that would be great!

PPS what's with the "wrap" attribute in textarea - is that depreciated now?

PPPS would using the regex shortcut of \s be a way to tackle this issue?

thanks in advance

Nick

what is the best format for urls when it comes to seo

forums_noreply@adobe.com — Fri, 04 Apr 2008 09:14:56 GMT

Hi guys

I’m building a site from the ground up, and today I am looking at the link structure.

Which is the best out of these would you say? – or is there a better option?

Option 1:
www.abc.com/somepage.cfm?productid=1234
- this is how our urls will look natively, not ideal.

Option 2:
www.abc.com/car-parts/fuel-systems/1234

- this looks nice but actually points to a *virtual* page that is several sub directories deep; im sure i read somewhere that the closer a page is the root the better google will rate it... so maybe this is better..

Option 3:
www.abc.com/car-parts-fuel-systems/1234
- less visually attractive to my way of thinking but perhaps google would rate this page higher than the option 2?

Option 4:
www.abc.com/car-parts-fuel-systems-1234
- my favourite I think – but I am no SEO expert

Option 5
www.abc.com/products.cfm/car-parts/fuel-systems/1234

How about this (which had been suggested to me but i don’t like). I don’t like it because it isn’t www3 correct is it?

Any comments would be gratefully received, than you very much indeed.

Is there a better way than the options I’ve put up here?

Thanks in advance.

Nick

multiple domains pointing to one application

forums_noreply@adobe.com — Wed, 02 Apr 2008 13:47:27 GMT

hi there

if you check these 2 sites out:

http://www.southendlocaljobs.co.uk/

and

http://www.chelmsfordlocaljobs.co.uk/

it looks to me like that is the same application that those 2 different domains points to, but pressumably the application is also passed a 'townid' so it knows what text variances to display.

this isnt my application but we have a need to do something similar.

we are running CF8 on windows sever (2003 i think).

is this something one handles in IIS? or via somesort of rule in application.cfm

does anyone know what is considered best practice with this?

what about duplicate content from google's perspective etc.

thanks very much indeed for any help you can offer.

Search Engine Safe query strings

forums_noreply@adobe.com — Wed, 02 Apr 2008 13:40:21 GMT

hi guys, ok i got a good one for you...

so ive heard that google (and users) like it if you chang:

www.abc.com/somepage.cfm?productid=1234

into

www.abc.com/products/red-ones/1234

or similar.

so if i'm going to do this which is the best format? (i'm building the site from scratch so have a blank canvass)

option 1:

www.abc.com/products/car-parts/fuel-systems/1234

this option - looks nice but actually points to a *virtual* page (www.abc.com/products/car-parts/fuel-systems/1234/index.cfm) that is several sub directories deep; im sure i read somewhere that the closer a page is the root the better google will rate it... so maybe this is better..

www.abc.com/car-parts-fuel-systems/1234 or www.abc.com/car-parts-fuel-systems-1234

-less visually attractive to my way of thinking but perhaps google would rate this page higher than the option1 one?

or how about this (which had been suggested to me but i dont like)

www.abc.com/products.cfm/car-parts/fuel-systems/1234

i dont like the above one as it isnt www3 correct is it? although i can see how it is possibly nicer than www.abc.com/products.cfm?carpartid=1234

so what do you guys think?

thanks very much indeed

Nick

i've installed mysql but now my queries take ages

forums_noreply@adobe.com — Mon, 25 Feb 2008 22:45:47 GMT

hi there,

i was running MS Access but have just installed MySQL.

i have used the mysql database converted to convert my old access db into a mysql one - i have checked what this semi automated process did and it seems to have been quite sensible (in terms of its choices of datatype etc)

naturally i have told cfadmin about this new datasource.

the problem is that now my queries take 1300% longer!

i have built a simple test page that runs two identical queries (select tablekey from tbl_bigtable where tablekey > 0)
once on the new mysql datasource and once on the old ms access datasource (the contents of each database is identical)

the ms access takes 250ms to run
the mysql takes 3375ms to run

how can this be?

my suspision is to do with how cf connects to mysql. when i was setting up the new datasource in cfadmin, i had to specify a "Server" field - which i set to localhost...

now, on my machine "localhost" is the cf build-in server - is it possible that this isn't up to the job of connecing cf to mysql?

i have installed IIS on my machine, but don't know how to tell Cf not to use it's build in server, but to now use IIS

i guess i could re-install cf and this time tell it to use IIS, but i'd rather not go through all this if i dont have to..

please help! - all suggestions greatly apprecied;

summary

Q1 - is my hunch about cf connecting to mysql correct?
Q2 - would connecing to the db via IIS be quicker?
Q3 - how do i tell cf to use IIS now, not it's in-built server

Microsoft Access database randomly locks itself??!

forums_noreply@adobe.com — Mon, 11 Jun 2007 14:38:19 GMT

Hi there

Our Access database is doing something weird. Every so often (I think when we've had a busy day in terms of traffic) a .ldb file randomly appears in the directory where our database file resides. Whilst this .ldb file is in existance the CF application can't read (or write) to the database and thus eventually CF times out and returns an error (or the user's browser gives up and displays a 404 error).

Sometimes this .ldb file dissapears of it's own accord after a second or so, but at other times it doesn't go away again and we have to restart the server.

- not ideal!

does anyone know why this occurs?

I've heard that running a deliberatly bad query (ie selecting from a non-existant table) can 'clear' this .ldb file - in fact we went as so far as to run such a query every 10 mintues as a scheduled task as a preventative measure - and although it 'feels' like this may have helped, we do still get these random .ldb files appearing every now and then and thus we have to restart the server :(

our site is getting busier (450,000 page impressions last month) so maybe we need to migrate to a new database (mySQL perhaps?)

however we don't want to go through all the pain of migrating to another database (is that hard to do?) only to find that wasn't the cause of our problem.

any input would be very gratefully received.

thank you very much.

How to have nice url's

forums_noreply@adobe.com — Thu, 01 Nov 2007 23:22:54 GMT

hi there

currently the url's on our site look like this www.outsite.com/some_page.cfm?var=1234&another-var=56787

but we want url's like this www.oursite.com/something/else

is this called mod rewriting?

is this possible to do in CF?

or does this require something to be installed on our server?

we're running CF8 on a windows server

thanks very much indeed for any info you can provide, even if it's just a link to livedocs somewhere!

cheers

I have to clear my CF "Template Cache" everytime :(

forums_noreply@adobe.com — Sat, 01 Apr 2006 09:55:43 GMT

Hi - Has anyone else experienced this fustrating problem?

I'm running dreamweaver 8, CF mx (developer copy), MS access DB & IIS (and it did the same before when i was using the CF built in webserver).

I make a change to a file, "put" it to my local machine using dreamweaver (the old file is definitely overwritten), go to a browser (IE and Firefox both perform the same in this scenerio) - yet it seems CF is still serving up the old version of my file.

The only cure it seems is to keep CF admin running on the "Server Settings > Caching " page and click the "Clear Template Cache Now" button after EVERY little change I make - Grrr

I've tried doing ctrl+F5 in browser to get latest version of page, and my internet settings are set to get latest version of the page. admitidly i haven't yet put any "no cache" instructions in my headers - could it be that?

Or is there a CF admin setting i've missed perhaps?

Any help would be very gratefully received.. Thanks very much to you all.

Nick

anyone know of an (in browser) image cropping app?

forums_noreply@adobe.com — Sun, 06 Aug 2006 16:56:19 GMT

hi there - I need to display an image, allow my admin users to crop that image and then save the new version of that image server side.

The interface doesn't need to be very flashy as this is only for admin users - it could be flash or javascript based or maybe a java applet?

I could of course (slowly) build one using cfx_image - but i think i'd struggle with the GUI aspect of this - plus why reinvent the wheel, right?

thanks very much indeed for any pointers anyone can give me - thank you

do I need to use CFLOCK with session variables?

forums_noreply@adobe.com — Sat, 09 Jun 2007 20:19:07 GMT

hi there - I am using session variables to keep track of my users who are signed in to my application

eg when a user signs in we set session.userID = '100' (if that user's ID is 100)

do i need to use cflock everytime i read that session variable?

eg if i do this..

<cfif isdefined("session.userID") and session.userID eq 100 >welcome back Fred</cfif>

do i need to actually do this..

<cflock scope="Session" type="ReadOnly" timeout="30" throwontimeout="no">
<cfif isdefined("session.userID") and session.userID eq 100 >welcome back Fred</cfif>
</cflock>

or perhaps i only need to use cflock when we set or change the session variable?

all input very gratefully received

PS the reason i'm asking this is that i think using CFLOCK all over the place is causing performance issues on our access database (i can explain more about this if you wish)

thanks very much

Nick

Best way to handle click throughs from my site whilst keeping referrer info intact

forums_noreply@adobe.com — Fri, 09 Mar 2007 14:33:12 GMT

Hi there - when users click an advert on my site i open a new window using <a href="page-on-my-site.cfm?advertiserID=1 target="blank" >

in page-on-my-site.cfm i do a query using url.advertiserID to return the advertiser's url

i then use cflocation to send the user off to the advertiser's website.

this is fine - i like this approch because:

a. the advertiser's site is opened in a new window
b. my page-on-my-site.cfm page records the click through in my db before cflocation sends them to the advertiser's page

however - this technique doesn't seem to pass my website's url as the "referrer" - therefore the advertiser can't see how many new visitors we're sending him.

does anyone have a better solution? ideally one that allows me to track click thoughs (leaving my site) and that causes the advertiser's site to open in a new window?

thanks very much indeed

CFX_Image seems to resize ok but the file size is too big??

forums_noreply@adobe.com — Fri, 09 Mar 2007 15:14:37 GMT

my host uses CFX_IMAGE v1.6.6.11 ( http://80.79.138.227/cfximage/index.cfm )

which does a perfectly good job of resizing images except for the fact that the resultant file size is too large. i found that compared to resizing images locally, resizing using this tag resulted in file sizes of double the size.

i have tried tweaking the "quality" paramater but without success, i could get the file size down but then the quality was poor.

so i am forced to resize images locally using macromedia fireworks or MS paint before uploading them.

ideally i need to be able to resize images server side but without inordinate file sizes.

does anyone else use a cfx_image tag that's more efficient? or does anyone else know how to get this tag to perform better?

any help would be very gratefully received.

thank you

How to manually insert an extra row of data in to a record set

forums_noreply@adobe.com — Thu, 01 Mar 2007 18:58:52 GMT

hi there, i have a standard query which gets me some rows of data

is there a way to manually add in an extra row of data (an position that as row number 1 in the recordset)?

i've tried to find something on this in google / live docs - but alas to no avail

if anyone could give me a pointer in the right direction (just a tag would be a help) i'd be very grateful indeed.

thanks very much

how come when i insert a decimal number into my DB it gets rounded up?!

forums_noreply@adobe.com — Wed, 24 Jan 2007 20:45:35 GMT

hi there - i have this..

<cfquery datasource="blah">
INSERT INTO tbl_bookings
(bloo)
VALUES
(12.34)
</cfquery>

but when i look in the db directly i can see that only 12 is being recorded (the .34 is being lost?!)

i'm using an MS Access database

and help would be very much appreciated - thanks very much indeed.

Which host - any views on Firstserv?

forums_noreply@adobe.com — Wed, 15 Nov 2006 18:51:31 GMT

Hi there - I currently host with Firstserv and I have found them to be very professional - but I'm only on a shared server and my site now needs a bit more room to grow etc so I'm about to sign up for one of the their VPS (virtual private server) deals.

Just before I do though I figure it prudent to ask if anyone has any comments to make regarding their experiences with this company (good or otherwise)

All input very gratefully received.

Thanks very much.

creating pdf pages from CF - how to control the font

forums_noreply@adobe.com — Sat, 21 Oct 2006 15:21:25 GMT

hi there - i have this..

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>pdf test page</title>
<style type="text/css">

</style>
</head>

<body>

<cfdocument format="pdf" pagetype="a4" orientation="portrait" unit="cm" margintop="2" marginleft="1.5" marginright="1.5" >
<span class="style3">
hello this text should be in tahoma, not times new roman!
</span>
</cfdocument>
</body>
</html>

which creates a pdf as desired - however the font is times new roman - not tahoma. i've tried with several different fonts and it is as if this only works with times. i have checked in cf admin "font management" in case it's something to do with that - but is says tahoma is installed and available for pdfs.

any suggestions would be gratefully received - thank you very much

how to create a new column in an existing table without uploading a new db file

forums_noreply@adobe.com — Sat, 14 Oct 2006 08:47:55 GMT

hi there, i often find myself needing to add new columns to a table. currently i choose a quiet time of day, download the db from my live server, quickly open it up and add in my new column, then upload it back to the live server - whilst hoping that none of my visitors a) changed anything during this process and b) that no one exeperinced any errors

..not ideal!

is there a way to create new columns in tables (and even to create new tables perhaps) via CF so i dont have to do this downloading / uploading procedure to my mdb documnet (i'm using an access database by the way)

i'm thinking something like this??...

<cfquery datasource="blah">
CREATE COLUMN name="new_variable" type="yes/no"...?
</cfquery>

is there such a thing? thank you very much indeed for any assistance you can provide.

how to stop a hacker putting SQL in to your query strings

forums_noreply@adobe.com — Sun, 13 Aug 2006 17:14:10 GMT

Hi there

i am looking for a way to "validate" data that arrives as part of the query string

for example if i have this..

<cfquery name="blah" datasource="blahblah">
select *
from tbl_blah
where something = #url.var#
</cfquery>

all's well and good until some bright spark edits the url and changes var to be something naughty (yesterday someone passed "drop database" to one of my pages in this way!)

is there a best practice for checking data that arrives as a url variable is of the correct type

thank you very much indeed.

PS currently if the passed data is text i tend to run a load of cfif's in the query

eg
<cfquery name="blah" datasource="blahblah">
select *
from tbl_blah
<cfif isdefined("url.var") and url.sex EQ 'blue'> WHERE var='blue'</cfif>
<cfif isdefined("url.var") and url.varEQ 'red'>WHERE var='red'</cfif>
</cfquery>

which is a bit of a pain - but what if the var is a number from 0 to 1000?! you can't have 1000 cfif statements in every query can you?!

thanks guys

please help my CF site just got hacked (a bit)

forums_noreply@adobe.com — Sun, 13 Aug 2006 10:39:10 GMT

hi there - my first CF site just got hacked a little bit - fortunately nothing particularly malitious - but none the less it's not a nice feeling and it has reminded me that i need to put some effort into checking user form data before i save it to my DB.

my website allows users to send messages to one another (a bit like a dating website), what someone has done is registered for an account in the usual way and then sent many messages to others, but the messages contail some javascript.

the hacker's idea behind this seems to be that that when the recipient of the message displays the message in their browser, the javascript would run and cause the client's browser to redirect to a page which would cause the recipient to add the sender (hacker) to their favourites. - which wouldn't have been the end of the world - but they could have tried to do other more naughty things and for all i know they could try again today..

now as it happens this didnt work as i saw the unusual activity and stopped their messages from going anywhere - however i need to stop this happening again.

my thoughts are - is there a CF tag that strips a variable of any html? - if so i could implement that on all my forms.

alternatively i could do a "find and replace" on any instances of "<" or ">" in user form data and replace those characters with an ASCI code or similar - which pressumably would dissable any javascript of html contained therein - what do you guys think?

any advice here would be very much appreciated as i'm sure many of you must have considered these things previously - is there a CF insustry standard for securing one's application against this sort of thing?

thanks very much

please help with some basic javascript syntax

forums_noreply@adobe.com — Wed, 19 Jul 2006 17:56:50 GMT

Can anyone please help me with a "remove from favourites" facility i'm working on.

I query to get all the favouites, then i output those favourites down the page

each favourite has a "remove from favourites" link - i want to make it so when a user clicks this link they get a javascript confirm box pop up saying "are you sure you want to remove #favourites name# from your favourites?"

so i have..

function remove(profile,name) {
if (confirm("Are you sure you want to remove #name# from your favourites?")) {
window.location = "remove_from_favourites.cfm?deleteFavID=#profile#&removedName=#name#"
}
}

and

<div onClick="remove(#rs_favs.favouriteeID#,#rs_favs.firstName#)" >Remove from favourites</div>

but it doesn't work - i think there are 2 problems..

problem 1 - i have used the CF # in the remove function as i don't know what one does in javascript to "output" a variable (see where it says "Are you sure you want to remove #name# from your favourites") what should i use in place of the "#"?

problem 2 - i have tried to pass to variables to the function >> onClick="remove(#rs_favs.favouriteeID#,#rs_favs.firstName#)" and i have separated them but a commer "," but i suspect that is incorrect syntax

if anyone could please help me i'd be very grateful as, to be honest, i love coldfusion - but javascript just hurts my head! :(

thanks very much indeed.

PS the way i've wrapped my "remove from favourites" text in a div rather than making it an actual "a href" link - is that right or is there a better way (ideally i'd like the text to look like all my other links (ie they underline on mouse over)

help with ORBER BY in my query when negative numbers are involved

forums_noreply@adobe.com — Fri, 12 May 2006 19:45:47 GMT

hi,

I have

SELECT *
FROM my_table
WHERE age = 5
ORDER BY photoSmall DESC

my_table looks like this:

key | age | photoSmall
1 25 2
2 25 3
3 25 1
4 25 -1

now, i would expect my results to be ordered as follows:

firstly record 2 (because it has the highest "photoSmall" value of 3
then record 1 (it has the next highest "photoSmall" value of 2)
then record 3 ("photoSmall" being 1)
finally record 4 ("photoSmall" of -1 being the lowest value of all..

but no!

it seems CF is treating -1 and 1 as being the same, how odd

do i need to amend my query to:

SELECT *
FROM my_table
WHERE age = 5
ORDER BY photoSmall DESC CFpositive_numbers_are_greater_than_negative_numbers=YES ??

any help would be greatly appreciated - thanks very much indeed.

updating one field with another (which contains a time stamp)

forums_noreply@adobe.com — Fri, 19 May 2006 20:44:52 GMT

hi there

i am trying to acomplish what i thought was a simple task of updating one field in my db using the contents of another

in my tbl_profiles i have:

key | penSignedIn | lastSignedIn
73 | | 2006-05-19 21:14:56.0

I am trying to update my table so the tbl_profiles.penSignedIn field is populated with the contents of tbl_profiles.lastSignedIn

<cfquery datasource="nya">
UPDATE tbl_profiles
SET PenSignedIn = #rs_user.lastSignedIn#
WHERE profileID = 73
</cfquery>

i am getting this CF error "Syntax error (missing operator) in query expression '2006-05-19 21:14:56.0'. "

and CF says "SQL : UPDATE tbl_profiles SET PenSignedIn = 2006-05-19 21:14:56.0 WHERE profileID = 73 "

which looks ok to me!! i've tied various different formats such as
SET PenSignedIn = {ts '#MM_rsUser.lastSignedIn#'}
SET PenSignedIn = #MM_rsUser.lastSignedIn#
SET PenSignedIn = '#MM_rsUser.lastSignedIn#'

but none seem to work which is driving me up the wall!! - can anyone please point me in the right direction please

thank you very much indeed.
I have CF7 and Access database

Adobe Community : All Content - All Communities

Incorrect string value

cfform autosuggest pass 2 values (locationname and locationid)

bug in cfadmin > scheduled tasks? Updating a task breaks the password even though I didn't touch the password field

How to turn this Java into something I can use in CF?

coldfusion 11 I've installed it - how do I get to cfadmin?

cant update CF (Error occurred while installing the update: Failed Signature verification)

How to get 'name' from 'name@domain.com' using cf reg ex?

CF liscence - most cost effective way?

cfquery datasource="mydb" result="result" - used to work but now gives "Variable RESULT is undefined

Getting started with Ajax - how do I query the db without 'submitting' the page?

cf throws "RECRUITER is undefined in URL" error yet then reports query string =type=byrecruiter&amp;recruiter=271

using <cferror and appErrorHandler.cfm but only some types of errors caught in this way

cf to google adwords api?

CF function to parse/escape bad characters in xml for rss feed

do i need a UNION / or a JOIN or something else?

putting a '£' symbol in a cfmail subject line

scanning uploaded documements for viruses in CF

what's the MYSQL equivalent of WHERE len(column-in-db) gt 2

how to handle weird characters in form fields (like bullet points from Word docs)

can you amend Word docs using CF?

any suggestions on how to update production database when dev db has had tables added etc

are application variables 'user specific'?

<cflocation to a file located 'above' the httpdocs folder

client side spell checker - what do you guys use?

taking screengrabs of sites in CF

CF Ajax - how to make a small form 'pop up' over the existing content

getting started with cfc's - how do i pass a variable in?

can you not set a variable that's in the same scope as a query structure

storing whitespace in db that comes from textarea

what is the best format for urls when it comes to seo

multiple domains pointing to one application

Search Engine Safe query strings

i've installed mysql but now my queries take ages

Microsoft Access database randomly locks itself??!

How to have nice url's

I have to clear my CF "Template Cache" everytime :(

anyone know of an (in browser) image cropping app?

do I need to use CFLOCK with session variables?

Best way to handle click throughs from my site whilst keeping referrer info intact

CFX_Image seems to resize ok but the file size is too big??

How to manually insert an extra row of data in to a record set

how come when i insert a decimal number into my DB it gets rounded up?!

Which host - any views on Firstserv?

creating pdf pages from CF - how to control the font

how to create a new column in an existing table without uploading a new db file

how to stop a hacker putting SQL in to your query strings

please help my CF site just got hacked (a bit)

please help with some basic javascript syntax

help with ORBER BY in my query when negative numbers are involved

updating one field with another (which contains a time stamp)

cf throws "RECRUITER is undefined in URL" error yet then reports query string =type=byrecruiter&recruiter=271