You've almost got it:
JDBC URL - jdbc:mysql://localhost:3306/test
Driver Class - com.mysql.jdbc.Driver
Driver Name - MySQL Connector/J
HTH,
Adrian
>I can't create a mysql datasource in CF Administrator.
>
>If I use the following datasource settings in CF Administrator:
>
>JDBC URL: jdbc:mysql:
But when using CHAR within a SQL Statement don't you need to use a
REPEATSTRING or a TRIM statement for proper validation so ensure that the
value in the database matches the same length of the variable itself?
I mainly use VARCHAR set to a size of the largest value expected. I only use
CHAR when
>What are the benefits on using a CHAR field versus VARCHAR?
>
Well, using char can be a bit speedier when querying, but takes up more disk
space. You want to use char when all the data in that field will be close to
the same length. the db will pad it, so it ends up taking up more space than if
What are the benefits on using a CHAR field versus VARCHAR?
I know with a CHAR(10) field that if the data is: START then the actual
value is: "START_ _ _ _ _" rather than a VARCHAR(10) of "START".
~|
Create robust e
lol
Will's more like the family dog that gets beat.
>I forgot to mention the entertainment value of the
>"family feud" between you, Dave1, and Will. :o)
>
>Rick
>
>>
~|
ColdFusion is delivering applications solutions at at top
Try this:
Change this line
if (o.type=='text'||o.type=='password'||o.type=='hidden'){
to
if (o.type=='text'||o.type=='password'||o.type=='hidden'||o.type=='file'){
And add this to your form tag
,'attachment_1','#q','0','Please upload an abstract'
After
'email','S','2','Please enter a v
What version of ColdFusion are you running. There is a special connector that
you may ahve to install to enable you to connect to a MySQL database.
It is the mysql-connector-odbc-3.51.21-win32 available form the MySQL website.
Download it and instal and then you also have to place a copy in a f
Hi there
I was just looking at your product Terraform and am interested in getting some
more information on the product and possibly even purchasing it (for a future
project).
One piece of info I am after right now â is this.
I have a site developed -
http://conference.bellamedia.com.au/cal
I can't create a mysql datasource in CF Administrator.
If I use the following datasource settings in CF Administrator:
JDBC URL: jdbc:mysql://localhost:3306/test
Drive Class: MySQL Connector J
AND (note the emphasis) I set my local and remote folders in my DW site
local folder, remote folder an
Thanks for the input. It is very helpful.
-Original Message-
From: Jim Pennington [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 27, 2007 10:46 AM
To: CF-Talk
Subject: Re: How good is cfreport?
I've been using Crystal Reports viewed via the web for sometime. As I am
using an IIS ser
To copy existing projects along with local history, copy the folder
.metadata\.plugins\org.eclipse.core.resources from your workspace.
You can also copy the snippets folder. The default location is
.metadata\.plugins\org.cfeclipse.cfml\snippets, or you can check CFEclipse
preferences if they're
hi,
jquery has some plugins to do dynamic dropdowns. The footprints for jquery and
the plugins are fairly small, and the ramp up time to use it in production is
insignificant.
http://jquery.com
~|
Check out the new features
> Hi All,
>
> Can I get some help figuring out how to connect two dropdowns
> dynamically?
I do it like charlie said, but I use mxajax.
Works nicely, and I even have up to 8 related menus.
Will
~|
Download the latest ColdF
Ben Forta wrote a post back in May that covers the basics of how to do
this with CF 8:
http://www.forta.com/blog/index.cfm/2007/5/31/ColdFusion-Ajax-Tutorial-2-Related-Selects
Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
___
James,
Yes, it would cost money but not expensive...
It has nothing to do with Verity nor Google. What's your email address? We
could discuss more offline.
Don
> dl,
>
> I was the one who posted about Verity.
>
> Sadly, I didnt understand your email or find any more information on
> your w
>Another way to look at it, kinda, is that CF8 integrates with server side
>.NET stuff, but not client side .NET stuff, like the ASP.NET UI controls.
I see the point you're trying to make, but this isn't really accurate. An
ASP.NET "control" is equivalent to a CFML tag, and is rendered completely
just to throw another option out there... it could potentially all be
done client side via javascript. create a 2d javascript array based
on your query data. the onchange event from dropdown 1 would update
the options in dropdown 2 based on that array.
On Nov 27, 2007 11:35 AM, Steve Sequenzia <
dl,
I was the one who posted about Verity.
Sadly, I didnt understand your email or find any more information on your
website.
What exactly is your approach? How would I implement it on my site? Is it
proprietary? Does it build on verity? Does it cost money?
> Greetings to all,
>
> I know
Hi All,
Can I get some help figuring out how to connect two dropdowns dynamically?
I am working a shoe database and I need to allow the user to select a size from
a dropdown and then from there I need to have another dropdown called quantity
updated with the amount of quantity based on the size
Hello all,
In the past, I applied a global template by creating header and footer
includes. However, I am impressed with the implementation of templates and
subtemplates by Model-Glue:Unity for the view. The problem is MG:U may be
overkill for our small projects. Is there a simple solution to a
Not really, ASP.NET is not part of the integration story.
Another way to look at it, kinda, is that CF8 integrates with server side
..NET stuff, but not client side .NET stuff, like the ASP.NET UI controls.
--- Ben
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent:
Now that everyone is back from the Holiday I'd like to try again.
When I use cftrace on my local IIS or Apache Cold Fusion server the line
number and file that the function was called from is displayed.
When I do the same thing on our UNIX development server it always displays
cfusion\wwwroot\WEB
Greetings to all,
I know Verity and Google search etc. etc. Try the following if you're
interested in the topic, but before you begin let me issue some warnings:
a) I'm not implementing some of the stuff that a beginner programmer would have
implemented such as telling peole, oh query does not
I had issues with my proxy server effing things up here at work. Have you
ruled out that possibility?
On Nov 27, 2007 11:07 AM, Asim Manzur <[EMAIL PROTECTED]> wrote:
> using latest eclipse v3.3.1.1 Build id: M20071023-1652
>
> trying to use the debugging option.
> for Ref. I use the Ben's post
Thanks for the reply Tom,
Are you talking about one thread for all the cfmails (outside the loop), or
one for each mail? I'm assuming the latter wouldn't be a good plan where
there might be thousands of emails, particularly on CF8 Standard.
Also, with the former option, if the thread was named
I need to index a pdf document into plaintext, and insert that text into a
database column - not put it into a collection. Anyone ever done anything like
that before?
My goal is to make pdf/word documents searchable but at the same time be able
to tie them back to a database record.
So the .net code would then call whatever controls you wanted to use.
Or is there a complete disconnect between ColdFusion and .Net controls?
Sorry for putting out inaccurate information. :)
--
Scott Stewart
ColdFusion Developer
SSTWebworks
4405 Oakshyre Way
Raleigh, NC. 27616
(703) 220-2835
Actually, that won't work. CF8 can consume .NET classes etc. You have access
to the .NET framework and any .NET code you write yourself. But CF cannot
use ASP.NET controls.
I see that Vince also responded, and he is correct.
--- Ben
-Original Message-
From: Scott Stewart [mailto:[EMAIL
Yes, this is possible with BlueDragon.NET (I can send you an example if you
need it). No, I don't think this is possible with CF8, because CF8 does not
provide any integration with ASP.NET, and .NET controls require the ASP.NET
runtime context. CF8 integration with .NET is done via a separate Wi
using latest eclipse v3.3.1.1 Build id: M20071023-1652
trying to use the debugging option.
for Ref. I use the Ben's post here
http://www.forta.com/blog/index.cfm/2007/5/30/CF8-Debugger-Getting-Started
But every time it comes back with the error
unable to contact the rds server.
It is the standar
I've been using Crystal Reports viewed via the web for sometime. As I am
using an IIS server I've been using asp pages and it works great. I am using
a program called recrystallize (www.recrystallize.com) which is a wizard
that processes your rpt file and you need to provide the database connection
>Yea, Dan beat me to it, but that is what I meant in my post.
>
>I've never had luck, like others who have responded, with exporting
>settings
>or plugins. easier to just install a clean new install in another folder.
Just to further elaborate. The last time I tried to migrate my installation
to
On Tuesday 27 Nov 2007, Will Swain wrote:
> will look at implementing something that prevents this from happening - I'm
> think CFTHREAD is perfect here. Anyone have any thoughts on this?
Yes, CFTHREAD the sending assuming the mail server can handle it.
A simple thing to do for the button is use j
> Get rid of the "*" in the SELECT *
Ben,
That did the trick. Thank you!
Nicholas Vacek
Vivid Image - Programmer
320-587-8974 ext. 111
[EMAIL PROTECTED]
http://www.vimm.com
Ben Nadel wrote:
> Get rid of the "*" in the SELECT *. Using CFQueryParam causes the
> structure to be cached. Then, if
You should be able to with CF8.
Call it as a cfobject
--
Scott Stewart
ColdFusion Developer
SSTWebworks
4405 Oakshyre Way
Raleigh, NC. 27616
(703) 220-2835
http://www.sstwebworks.com
http://www.linkedin.com/in/sstwebworks
Boycott Sys-Con
http://www.sstwebworks.com/blog/index.cfm/2007/10/
Yea, Dan beat me to it, but that is what I meant in my post.
I've never had luck, like others who have responded, with exporting settings
or plugins. easier to just install a clean new install in another folder.
On Nov 27, 2007 9:26 AM, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote:
> Andy,
>
>
On Tuesday 27 Nov 2007, Jim Davis wrote:
> I agree... but Eclipse really needs to consolidate and streamline the
> upgrade process. It's ridiculous to do this for every point release.
I *believe* that it's on the roadmap somewhere to support upgrading Eclipse
itself, not just plugins, via the cu
Andy,
>What settings are you talking about?
>
>Is there a single file, or a folder?
>
>Do I have to reinstall all my plugins as well?
I'd recommend just extracting Eclipse v3.3 into a new folder and then
re-installing the plug-ins (as I stated in another thread.)
I think in the long run it'll ma
Hello All,
I have had the following request past onto me:
Can we pass CF a .net 3.0 dll containing a control - say the calendar
control, and then allow CF to consume this dll and display the
calendar.
I am using CF8 and I am aware that BlueDragon could be a possible
answer to this, I was wonderi
Not positive on this, but I believe the multiple query thing was handled
with CF 8...
Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com
Kris Jones wrote:
>> You should be able to do prett
Crow...
What settings are you talking about?
Is there a single file, or a folder?
Do I have to reinstall all my plugins as well?
andy
-Original Message-
From: Crow T. Robot [mailto:[EMAIL PROTECTED]
Sent: Monday, November 26, 2007 4:25 PM
To: CF-Talk
Subject: Re: Updating to Eclipse
Thanks for the reply Dan,
I take your point on the code. It's just that the actual code is really
rather simple:
Send the email
Log that the email address was not valid and don't send email
The query is returning the expected data - I've tried dumping it and I can
see
> You should be able to do pretty much anything that Crystal Reports
> supports with the built-in and the (free) Report Builder.
> Talk to Dean Harmon at Adobe if you have specific questions (since he
> wrote most of the reporting subsystem).
Sorry, but I'm not convinced of this. I've written som
> -Original Message-
> From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 27, 2007 8:50 AM
> To: CF-Talk
> Subject: RE: Updating to Eclipse 3.3...
>
> >> from 3.2 to 3.3; I think you have to simpy install 3.3.
> Unfortunately, I
> >> don't know how to preserve or
>> from 3.2 to 3.3; I think you have to simpy install 3.3. Unfortunately, I
>> don't know how to preserve or import settings.
>
>File, Export, General, Settings.
My personal experience is it's just easier to rebuild. I've tried the export
settings, but it's caused me problems in the past.
I think
Will,
>We recently upgraded our server to CF8.
>
>We have a number of clients who use emailing tools to send out emails to
>opt
>in lists. One of these clients did a mailout last week to a couple of
>lists,
>and it would appear that the emails all went at least twice to every member
>of the list.
On Monday 26 Nov 2007, Mike Garner wrote:
> we are seeing that ColdFusion is issuing the stored proc call twice for a
> single transaction and have verified it is not due to multiple clicks
How ?
> Just curious if there are any known threading issues with CF and Oracle
> stored proc calls in Ora
Here's the solution:
Use
NOT
For some reason CF doesn't see an uploaded file if u use the string notation
FORM['file1'] to reference the file upload field instead of dot notation
FORM.file1
This occurred on CFMX 8
(and Apache 2.0.59, WinXP SP2 fwiw)
Marc
Here's the solution:
Use
NOT
For some reason CF doesn't see an uploaded file if u use the string notation
FORM['file1'] to reference the file upload field instead of dot notation
FORM.file1
This occurred on CFMX 8
(and Apache 2.0.59, WinXP SP2 fwiw0)
Marc
~~~
A related question -
Is this a good place to use the new CFTHREAD tag? Strikes me that it
probably is. Would you put it inside the loop and create a new thread for
each email sent, or create one new thread separate to the page thread to
handle all the emails. I've not used this tag before and am
I forgot to mention the entertainment value of the
"family feud" between you, Dave1, and Will. :o)
Rick
> -Original Message-
> From: Dave l [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 27, 2007 1:46 AM
> To: CF-Talk
> Subject: Re: image effects
>
> I come here just to pick on Wil
On Monday 26 Nov 2007, Andy Matthews wrote:
> Have any of you seen some sort of image manipulator for Flex? I'm just
> looking for really basic stuff like scaling and rotating (then saving).
Should be possible, rotate/scale is built into Image, and I think you can
snapshot any Flex component.
-
Hi,
We recently upgraded our server to CF8.
We have a number of clients who use emailing tools to send out emails to opt
in lists. One of these clients did a mailout last week to a couple of lists,
and it would appear that the emails all went at least twice to every member
of the list. The code
On Friday 23 Nov 2007, j s wrote:
> Can anyone recommend some titles on Flex 2 with focus on CF and AS3.
Given the 'real soon' release of Flex 3, you might want one that does that.
--
Tom Chiverton
Helping to globally harness sexy systems
on: http://thefalken.livejournal.com
**
On Monday 26 Nov 2007, Dave Watts wrote:
> from 3.2 to 3.3; I think you have to simpy install 3.3. Unfortunately, I
> don't know how to preserve or import settings.
File, Export, General, Settings.
--
Tom Chiverton
Helping to heterogeneously brand next-generation e-business
on: http://thefalken
On Nov 26, 2007 2:28 PM, Billy Cox <[EMAIL PROTECTED]> wrote:
> Does anyone have experience with outputting Crystal Reports using
> ColdFusion? We have a number of existing Crystal Reports that I would like
> to leverage if possible. I am also making a purchase decision between Blue
> Dragon Server
About 10 mins later I figured this out with isBinary and BinaryEncode(blah,
"Hex"), in case anyone comes across the same issue.
-Original Message-
From: Matt Barfoot [mailto:[EMAIL PROTECTED]
Sent: 26 November 2007 23:27
To: CF-Talk
Subject: Oracle RAW(50) - string conversion
When I cfqu
57 matches
Mail list logo