that you
don't have something else wrong. Perhaps uninstall/reinstall the
plugin.
On 8/20/07, Chad Gray [EMAIL PROTECTED] wrote:
I am trying to install the new CF Extensions that Dean posted
http://www.cfreport.org/index.cfm/2007/8/17/Eclipse-33-and-the-ColdFusion-Extensions-for-Eclipse
and I get
Anyone know where I can find a list of new Tags and Functions in CF8?
I keep finding tags/fucntions that I had no idea existed.
Chad
~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now
: list of new stuff in CF8
Go to the PDFs - in the Reference, under tags and functions, you will
find a list of changes since CF5. I bet you will find stuff added to
CF7 you didn't know about either! :)
On 8/15/07, Chad Gray [EMAIL PROTECTED] wrote:
Anyone know where I can find a list of new
I saw a recent post about images and IPTC and EXIF and CF8 able to access the
embedded data.
What about XMP? Maybe I am mistaken but im pretty sure XMP data can be stored
in images. Can CF8 access XMP data on a file?
Thanks!
heidiSQL formerly MySQL Front.
http://www.heidisql.com/
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 09, 2007 9:17 AM
To: CF-Talk
Subject: MySQL front end...
Besides Aqua Data Studio, what else is out there that is free and runs on
Windows.
It does CSS? I wonder which one I installed, because I have never gotten CSS
and that is the missing link to get me off of Dreamweaver.
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 10:14 AM
To: CF-Talk
Subject: Re:
.
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 10:40 AM
To: CF-Talk
Subject: RE: Eclipse/CFEclispe
It does CSS? I wonder which one I installed, because I have never gotten
CSS and that is the missing link to get me off of Dreamweaver
ImageCR works great. We use it for our photography studio's proofing web sites
that I built. It can handle the large images you are talking about and caches
the resized image so it does not have to be processed every time the page is
requested.
It also has a sharpen setting if you find that
will install it.
If not, may have to change to a new provider.
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 07, 2007 9:42 AM
To: CF-Talk
Subject: RE: CF / Alagad / Photography Questions
ImageCR works great. We use it for our photography studio's
I have had problems in the past where cfdocument would not pull in an image.
I figured out that because the directory had NTFS permissions on it that the
IUSR (anonymous) user was not allowed to load the image cfdocument could not
load the image.
Maybe you are running into the same thing that
The file name cannot have a space on the front of the file name in a windows
environment.
Of course you can on Mac so if you are using Mac file services on your PC
server and a Mac made the file on the windows machine this would be possible,
but windows file system will not like it.
I also like to use val() on any integer like your ProdID appears to be an
integer.
This way val() will take text and convert it to 0.
But yes use your CFQueryParams! This is the best line of defense.
-Original Message-
From: Rick King [mailto:[EMAIL PROTECTED]
Sent: Monday, August
Ray blogged a link to the downloads.
http://www.coldfusionjedi.com/index.cfm/2007/7/30/ColdFusion-8-Eclipse-Extensions-now-available-separately
http://www.adobe.com/support/coldfusion/downloads.html
-Original Message-
From: Leitch, Oblio [mailto:[EMAIL PROTECTED]
Sent: Friday,
I have a feeling you did not get a response because the email side of CFTalk
seems to be really hit and miss for the last week.
I had to go to the web site to see any of your thread on this subject.
CF has great documentation on web service usage.
http://livedocs.adobe.com/coldfusion/7/
Look
Is there a best practice when creating an object?
Do you store your objects in the session or application scope so you can use it
through out the application? Or do you create your objects only when you need
to?
I suppose it is a case by case decision.
Is there an application out there that
I am cleaning up my CFC code adding cfset var foo = and hit this error
What does it mean?
Local variable i on line 33 must be grouped at the top of the function body.
~|
Check out the new features and enhancements in the
With query of query you don't have database functions like LEFT() because you
are not running your query on a database engine like MS SQL or MySQL.
Do a CF left() function when you output your data.
-Original Message-
From: Dae [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 01,
Ok now that I have learned about declaring variables in CFCs so you don't run
into race conditions and problems. How about application.cfc?
Do I need to use cfset var foo = in application.cfc?
~|
Enterprise web
You might want to look at using iText. Here is a CFC that shows some code that
uses iText to place images.
http://www.reactivevision.com/coldPDF.txt
I have not experimented very much with CFDocument and exact placement of items,
but the results I have seen are very inconsistent. I think
I started playing more with cfdocument. The below code fit a div with a 1px
border exactly onto a 8.5x11 document. You move it 1px in any direction and it
gets funky... there is definitely some translation when going from HTML to PDF
when using CFDocument.
cfdocument format=pdf
I have noticed in a lot of people's code for CFCs they set all of the variables
being used in the CFC like this:
cfset var foo =
Why? Is this just good programming practice?
Also what scope are these variables in? variables.foo?
I installed the CF8 Dreamweaver updater and the help files are not local they
go to livedocs... and the URL doesn't even work.
http://www.adobe.com/go/livedocs_cf8docs
What good are help files if I have to be online to get to them?
Adobe really seems to be pushing Eclipse... are they trying
Hey Ben Forta, I want my money back. CFZip is built into CF8 and I purchased
it many o' years ago from you!
Just joking of course! :)
I have gotten my money's worth out of it that is for sure. I just thought it
was funny to see the tag in CF8.
not be overwritten by concurrent usage of the CFC
Print this out and place it on your cube wall. I did. :)
http://www.coldfusionjedi.com/downloads/cfcscopes.pdf
~Brad
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Monday, July 30, 2007 8:46 AM
To: CF-Talk
Subject: CFC
Thanks for all of the info on this subject. I have fixed most of my existing
code.
One question I have is what happens if I don't declare a name= attribute for
a cfquery?
IE:
cfquery datasource=#application.dsn#
Lots of sql here
/cfquery
I tend to do this on updates or inserts of a database
You say that the web service returns XML, why don't you work the XML with CF's
XML functions?
Do a CFDump on what they send and see what it is. If it is XML you will
probably need to run XMLParse() on it to turn it into a CF XML object. Then
run CFDump on it.
The CF documentation has some
Anyone know if iText is still being used in CF8 for PDF manipulation?
~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
If you go to the endpoint do you get a blank page? You should.
IE when I go here: http://demo.dev/flex2gateway/
The last time I played with Flex I put the endpoint in the RemoteObject. There
are probably a lot of ways to set it up though.
mx:RemoteObject
id=roServalent
Anyone know if you can place an image in a PDF in CF8?
Thanks,
Chad
~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
I think I typed this out right... might be some typos. Basically use
XmlElemNew to create the new node then assign it's XmlAttributes and XmlText to
what you want.
cfset xml = XMLParse(#XMLgoesHere#)
cfset
I want cfcontent to take xml data from a query and force the user to download
it as an XML file.
Any tips?
I keep getting a CF Error if I put the xml in the variable attribute of
cfcontent.
java.lang.String is not a supported variable type. The variable is expected
to contain binary data.
Thanks Ian and Ben, I got is working now.
Next question. Firefox does not like the fact that the file name has spaces in
it.
With the below code the file that is saved is test
With IE it replaces the space with an underscore. test_1234.xml
cfheader name=Content-Disposition
value=attachment;
(NO single quotes)... Just remember to
escape them .
...
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 24
Ya I tried that, but you get the literal %20 in the name...
Ben's surrounding with double quotes fixed firefox to have the proper name, but
IE still replaces the blanks with underscores.
That is not too bad I would like IE to get the name absolutely right.
-Original Message-
I am trying to use CFDocument to make a PDF of a web page.
I have an image that produces what kinds of looks like a missing image icon in
the PDF. When I click on thing in Acrobat it says There was an error
processing an annotation or link. There was a problem reading this document
(14).
, and IIS_WPG has Read/Execute and list
folders.
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Monday, July 23, 2007 9:27 AM
To: CF-Talk
Subject: CDDocument Image problem
I am trying to use CFDocument to make a PDF of a web page.
I have an image that produces what kinds
I like HeidiSQL formerly known as MySQL-Front.
http://www.heidisql.com/
-Original Message-
From: OÄuz_Demirkapı [mailto:[EMAIL PROTECTED]
Sent: Monday, July 23, 2007 12:29 PM
To: CF-Talk
Subject: MySQL Client
Hi all,
I am using Navicat (navicat.com) as MySQL client now but I
I have a CRUD CFC that has this function and I load the CFC into the
application scope:
cffunction name=readZJF access=public returntype=query
cfargument name=criteria type=string required=yes
cfquery datasource=dsn name=readZJF
SELECT *
FROM
Thank Matt, Jim and Dan.
I see where you guys are going with this.
As far as security im not sure how using the array is any better.
I suppose once things are broken out using the array I could then validate the
data coming in with cfqueryparam.
This would keep people from tacking on
Ya... I was experimenting with an AIR app a while back and it connected to a
Coldfusion CFC. The session was created when the AIR app hit the CFC and the
session expired at the predetermined time.
You might have to build a cfc for the distributors web service calls to create
your session
I am writing a create database record function in my CFC.
Now one argument that is being passed in is data type of XML. So I use
cfargument and set the type to XML.
Now when I am doing my INSERT into the database I am using cfqueryparam and
noticed there is no cfsqltype of XML.
What should I
Ya... sorry I should have said MS SQL 2005 and the datatype is XML.
I experimented and used cf_sql_varchar with both a CF XML object and plain old
text and both worked fine. The CF XML object must be pretty close to plain old
text.
I wonder if CF8 will have an XML type to support MS SQL 2005.
I have a form that people fill out.
When they hit submit I want to make a PDF of data they submitted then pop open
an email in outlook with the PDF attached to it.
Then all the user has to do is fill in the email to send the PDF to and hit
submit.
Any suggestions on how to do this?
This wouldn't involve outlook, but I don't think you need it.
Use cfdocument to create the pdf and cfmail to send the E-mail attaching
the pdf to it.
Let the user type into a text area whatever they wish to be included in
the body of the E-mail.
~Brad
-Original Message-
From: Chad Gray
I am running fine with DW8 and Vista. No crashes.
I did upgrade from XP to Vista. So DW8 was already installed then I did an
upgrade from XP to Vista. Maybe that makes a difference.
-Original Message-
From: Jenny [mailto:[EMAIL PROTECTED]
Sent: Friday, June 29, 2007 11:35 AM
To:
So is there any advantage or reason I should be storing XML data in a XML field
vs. varchar??
~|
ColdFusion 8 beta â Build next generation applications today.
Free beta download on Labs
When using argumentcollection can you dump in a query? I have done
argumentCollection=form in the past to take the form structure from a page and
dump it in, but what about a query?
This returns a query with data from a database
cfinvoke component=com.mySite method=readRecord
Does any one have code or suggestions on using CFFTP to check an FTP server to
see if a file exists on the FTP server?
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build powerful, scalable RIAs. Free Trial
I have a function in a CFC that does an update on a database table.
cffunction name=updateTable access=public
cfargument name=id type=numeric required=yes
cfargument name=Feild1 type=string required=no
cfargument name=Field2 type=string required=no
cfquery
sending form fields...
cfset myInstance.updateTable(argumentcollection=form) /
you can send an array, you can send a struct... you can send any
number of simple variables wrapped up in a single complex var.
On 6/7/07, Chad Gray [EMAIL PROTECTED] wrote:
I have a function in a CFC that does
ID is defined.
Form Fields:
ID=75
FIELD1=test
FIELD2=test
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 07, 2007 11:48 AM
To: CF-Talk
Subject: RE: invoking a cfc function with minimal typing
Oh wow.. that looks powerful. They are form fields.
I
with minimal typing
On 6/7/07, Chad Gray [EMAIL PROTECTED] wrote:
Oh wow.. that looks powerful. They are form fields.
I get this error Variable COM is undefined. when trying it. I must have my
cfc's not configured right.
cfset com.mysite.ticketdata.updateTable(argumentcollection=form) /
If I use
: invoking a cfc function with minimal typing
if you're sending form fields...
cfset myInstance.updateTable(argumentcollection=form) /
you can send an array, you can send a struct... you can send any
number of simple variables wrapped up in a single complex var.
On 6/7/07, Chad Gray [EMAIL PROTECTED
Not quite sure what you mean, but if I understand right I would look at the
database for currently active or running queries. I would not look to do this
through Coldfusion.
MS SQL has a tool called the SQL Server Profiler.
-Original Message-
From: Claude Schneegans [mailto:[EMAIL
Does CFHTTP show up as a browser type that could be blocked?
I cannot download my Calvin and Hobbes comics anymore with the following.
cfhttp method=GET
url=http://images.ucomics.com/comics/ch/2007/ch070605.gif;
path=#variables.path# file=calvin#day#.gif
If I hit the URL:
Hmmm actually never mind.
It works on one of my computers but not another so I need to dig into why one
computer it works and the other it does not.
Thanks anyways!
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 05, 2007 5:35 PM
To: CF-Talk
I thought this would be an easy one but I cant get it to work.
I want a text input to change value when an option in a select box is changed.
I am looping over my options in the select with database information. Do I
need to use something other then onChange?
script
function
onchange=displayStockLevels(this.options[this.selectedIndex].value);
cfloop query=getPlates
option value=#getPlates.ID##getPlates.Name#/option
/cfloop
/select
On 6/1/07, Chad Gray [EMAIL PROTECTED] wrote:
I thought this would be an easy one but I cant get it to work.
I want a text input
I want to write a javascript function that I can use on all of my forms and
inputs to disable a text input. So I want to pass to the function the form's
ID and the text input's ID to be disabled.
How do I append the functions attributes to my document command?
My javascript below does not
I am working with a program that is going to send a chunk of XML to a web page.
I don't know how the XML is formatted from this program.
Is there any way to dump all data that is submitted to page.cfm and load it up
in an email to send to me?
I don't know if it is going to be a POST or GET
Yes data is being posted to my cfm page and I want to dump any data that is
posted to it in a email.
Id don't quite follow your example. What do you mean cfhttp call?
Thanks for the help!
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 02, 2007
I would like to make a page that will either be displayed as a PDF using
CFDocument or as plan old HTML.
I cant seem to do the below I get the error:
The end tag /cfdocument encoutered on line 6 at column 11 requires a matching
start tag.
cfif URL.Format EQ PDF
cfdocument format=pdf
I just watched one of Ben Fortas examples of using the CF function
sendGatewayMessage() to send data to a Flex app that was listening with
mx:Consumer.
If I heard right in his presentation this only possible with CF Enterprise
right?
I don't see a way to make a gateway in CF Admin (standard
I am using MS SQL and have a field with data type DateTime.
I want to find all records with the day 4/2/2007?
If I do
WHERE dateCreated = '04/02/2007'
I get no records and I have lots of records like this in the database:
4/2/2007 9:57:57 AM
4/2/2007 10:57:57 AM
4/2/2007 5:57:57 AM
4/2/2007
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 9:59 AM
To: CF-Talk
Subject: SQL question
I am using MS SQL and have a field with data type DateTime.
I want to find all records with the day 4/2/2007?
If I do
WHERE dateCreated = '04/02/2007
I tried that too and no records are returned.
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 10:09 AM
To: CF-Talk
Subject: RE: SQL question
How about using...
WHERE dateCreated LIKE '%4/2/2007%'
-Original Message-
From: Chad Gray
AH! This works!
Thanks!
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 10:10 AM
To: CF-Talk
Subject: Re: SQL question
Chad Gray wrote:
I want to find all records with the day 4/2/2007?
WHERE DATEDIFF(day, dateCreated,'4/3/2007')=0
On the (@date + 1) how do you know it is adding one day?
Out of curiosity how do you add one year?
Thanks for the clean elegant solution. I will try it out.
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 10:26 AM
To: CF-Talk
Subject: RE:
I just tried this and I get no records.
dateCreated = 04/02/2007 AND dateCreated (04/02/2007 + 1)
Is this method compatible with MS SQL?
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 10:41 AM
To: CF-Talk
Subject: RE: SQL question
DATEADD(DAY, 1, @someDate)
-Joe
On Apr 3, 2007, at 10:45 AM, Chad Gray wrote:
I just tried this and I get no records.
dateCreated = 04/02/2007 AND dateCreated (04/02/2007 + 1)
Is this method compatible with MS SQL?
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent
http://livedocs.adobe.com/coldfusion/7/htmldocs/1477.htm
Is this up to date for 7.0.2? I does not read like it is.
I am getting into Apollo and would like to connect my Apollo app to Flash/Flex
Remoting on my CF server. I hear it is faster then soap.
Chad
There is a Flex and Apollo yahoo group, but I have found them to be extremely
slow and I think it is moderated heavily. I found for best results you need to
post via the yahoo web site not your email program.
I waited 4 hours for a message to post.
Hello,
I am playing with cfcs and what I am reading so far I should be able to hit the
cfc with ?wsdl on the end and get WSDL.
Here is my test cfc right out of the help files:
cfcomponent
cffunction name = echoString returnType = string output = no access =
remote
cfargument name =
, March 19, 2007 10:13 AM
To: CF-Talk
Subject: RE: cfc and wsdl
Your CFC has to be set to remote.
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Monday, March 19, 2007 9:07 AM
To: CF-Talk
Subject: cfc and wsdl
Hello,
I am playing with cfcs and what I am reading so far I
:[EMAIL PROTECTED]
Sent: Monday, March 19, 2007 10:36 AM
To: CF-Talk
Subject: Re: cfc and wsdl
Check to see if either server has a root mapping (i.e. / is mapped to
something) and if there are any other differences between the mappings
on the boxes.
On 3/19/07, Chad Gray [EMAIL PROTECTED] wrote
They are not a CFCs, but CFXs and work great!
http://efflare.com/
ImageCR and ImageFlare are powerful tools and I have been using them for years
with millions of images with no problems.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 19,
cfsetting showdebugoutput=no
If you want it to be site wide stick it in your application.cfm
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Monday, March 19, 2007 11:30 AM
To: CF-Talk
Subject: Debugging?
Is there a way to have Debugging turned OFF for one site
Here are some templates I have used in the past. Fill in the [blanks].
Web Site Terms and Conditions of Use
1. Terms
By accessing this web site, you are agreeing to be bound by these web site
Terms and Conditions of Use, all applicable laws and regulations, and agree
that you are responsible
I have doing spaghetti CF sites for a few years now and have started to
understand the importance of separating your display code from your logic code.
Is there a best practice for using CFCs and CF?
I read the documentation on CFCs and there are lots of ways to use them.
You can use CFinvoke,
Michael, thanks for the links.
Do you take amex? My company CC is amex I would like to subscribe.
Feel free to reply to my email and take this off CFTalk.
Chad
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 18, 2007 5:26 PM
To: CF-Talk
Your paypal page does not have amex in the drop down.
http://www.fusionauthority.com/quarterly/
I clicked on the first link and that uses google, so I am set.
Thanks!
Chad
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 18, 2007 7:32 PM
To:
Whoops I mean to paste this address:
https://secure.houseoffusion.com/paypal.cfm
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 18, 2007 7:49 PM
To: CF-Talk
Subject: RE: CFCs and Best Practices
Your paypal page does not have amex in the drop
Thanks Dave, I think you are right that I need to pick up on OO concepts.
I have been picking at the head first object-oriented analysis and design
book, but kind of get lost in the java language since I truly don't know it.
I will keep reading and learning, thanks for your awesome response, it
Hello I am hitting a web service with cfinvoke.
cfinvoke
webservice=http://localhost/CumulusWS/services/Cumulus?wsdl;
method=getServerCatalogs
returnvariable=aServerCatalogList
cfinvokeargument name=connection value=#aConnection#/
/cfinvoke
cfdump var=#aServerCatalogList#
When
)
setServerCatalog (returns void)
getClass (returns java.lang.Class)
wait (returns void)
wait (returns void)
wait (returns void)
notify (returns void)
notifyAll (returns void)
toString (returns java.lang.String)
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Friday, March 16
Thanks Phil, I did the dump and it returned an array.
cfdump var=#aServerCatalogList.getServerCatalog()#
I do have the API so I will read some more.
array
1 object of com.canto.www._2005.cumulus.ws.types.ServerCatalog
Methods hashCode (returns int)
equals (returns boolean)
getName (returns
java.lang.Class)
wait (returns void)
wait (returns void)
wait (returns void)
notify (returns void)
notifyAll (returns void)
toString (returns java.lang.String)
Now I do
cfdump var=#aServerCatalogList.getServerCatalog(2).getName()#
And I get the name of the catalog.
-Original Message-
From: Chad
).getName())#br /
#javacast(string, aServerCatalogList.getServerCatalog(4).getName())#br /
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Friday, March 16, 2007 9:56 AM
To: CF-Talk
Subject: RE: webservice newbie question
Ah.. now I am starting to see where this goes.
I
from=1 to=4
cfoutput
#aServerCatalogList.getServerCatalog(javacast(int,i).getName())#br /
/cfoutput
/cfloop
'i' might be treated as a string there instead of a number,
Phil
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Friday, March 16, 2007 10:20 AM
To: CF-Talk
I need to send and receive data from a web service.
Can someone help me with how to send and receive data? What tags should I use?
I see one called CFInvoke.
Here is a section of the wsdl that I would like to try first. It is to make a
basic connection to the service.
- xsd:complexType
One of our clients had the idea to clean up their web server and now the CF
service wont start.
I found this error in this log file: C:\CFusionMX\runtime\logs\default-err.log
Error: no `server' JVM at `C:\Program
Files\Java\j2sdk1.4.2_09\jre\bin\server\jvm.dll'.
Error: no `server' JVM at
Is that an option in CF installer? I will load the disk and see.
Thanks!
-Original Message-
From: Webdevotion [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 21, 2007 10:56 AM
To: CF-Talk
Subject: Re: HELP
Can't you try a reinstall ? In stead of remove, choose repair ?
When you use ORDER BY in SQL on a text field it sorts the data like this:
1
11
12
13
2
21
22
Where I want
1
2
11
12
13
21
22
I cannot switch it to an integer field because there will be some text also.
Any way to accomplish this?
Thanks!
Chad
yourcolumn, 0+REPLACE(SUBSTRING_INDEX(yourcolumn,' ',1),',','') AS
sort
FROM yourtable
ORDER BY sort
/cfquery
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 8:13 AM
To: CF-Talk
Subject: SQL order by
When you use ORDER BY in SQL on a text field
Thanks Jim! That works great for me!
I will have to look up CASE, I am not familiar with that function.
Thanks again!
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 9:26 AM
To: CF-Talk
Subject: Re: SQL order by
Chad Gray wrote:
I
Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 8:52 AM
To: CF-Talk
Subject: RE: SQL order by
Thanks Jim! That works great for me!
I will have to look up CASE, I am not familiar with that function.
Thanks again!
-Original Message-
From: Jim Wright
I just got done installing Homesite on my new computer along side of CFEclipse
and Dreamweaver because I missed Homesites searching and replacing so much.
Homesite can search for carriage returns and replace them with commas... I love
that!
I can quickly take comma delimited data and replace
You got me pointed in a great new direction. I will figure out the details and
if there is a better function then isNumeric for the data I am dealing with.
Thanks!
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 10:18 AM
To: CF-Talk
I cant get it to work in Dreamweaver. Everytime I try to type a carriage
return in it executes the search.
How do you do it in dreamweaver?
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 12:58 PM
To: CF-Talk
Subject: RE: Quick CFEclipse
Efflare.com has ImageCR that can do what you want.
I use them all the time and they are rock solid applications.
Chad
-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 23, 2007 12:26 PM
To: CF-Talk
Subject: Image size
I am on CF5.0. Is there
401 - 500 of 853 matches
Mail list logo
