Yeah, clients are always going to want to know what it's going to look like.
However, I've found it extremely helpful to segregate the wireframing from the
design.
In my experience, most clients put the cart before the horse, concentrating way
too much (or too early, or both) on the
Did you look at SpreadsheetMergeCells()?
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-6734.html
In my own experience, there appear to be some formatting limitations to merged
cells, but this method will definitely do the trick of merging cells across
So my question is, how do I achieve a custom color with RGB
values above 127?
If memory serves, I _believe_ you can just deduct -256 whenever the
value is greater than 127. The result can then be cast as a byte. Of
course if my memory is faulty, you could also use: javacast(int,
I'm trying to create some custom colors to use in my formatting objects for a
spreadsheet I'm developing with cfspreadsheet. According to to POI docs, you
can do something like this to achieve a custom color:
cfscript
excel = spreadsheetnew(My Worksheet,false);
palette =
What is the purpose for putting the tree in the grid?
Personally, I would suggest Sencha's (ExtJS) tree. There is a pretty robust
OOTB tree with checkbox support. I've used it numerous times in the past, and
it's super simple to integrate with CF.
Here's the link:
This is more a question of curiosity than of anything else...but is there a way
in CF8 to call something equivalent to cfabort using the exposed java
methods? Or maybe another way, what is it that cfabort is actually doing?
If dat is already an object literal (as below), why do you need to serialize
it? Doesn't the the ajax() data take care of that for you if passing an object?
If I use serialize I get nothing passed as a post argument. I am
requiring all args and I get the error as normal, ...required but
There is plenty of sloppy code in the .Net-i-verse...like you said, it's
ultimately about the developer, not the platform.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of
Check out http://kuler.adobe.com/
This should get the inspiration flowing :)
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
You need to return and loop over result (what is being returned from your
component), not the method name.
I am having trouble pulling data from a cfc for a pull down menu. Here
is the code from the cfm file:
div id=sprynavHor style=z-index:100
ul id=MenuBar1
That is, returnvariable=result, and then loop over result.
You need to return and loop over result (what is being returned from
your component), not the method name.
~|
Adobe® ColdFusion® 8 software 8 is the most important
Unless I'm mistaken, you should be able to call the imageInfo() function on the
resized image -- see the docs for full description.
After I use cfimage to resize an image, are the attributes for the new
height and width available to me to put in the img src to show the
newly sized image?
At a certain point, this conversation becomes very unproductive. All IDE's
have their advantages and disadvantages--so which is better? Well, the answer
doesn't really have an answer because all offer different ways of doing things,
and each person has their own development needs.
So really,
I use Dreamweaver. I realize that it is not ideal for CF; however, as I pull
double-duty as a designer and developer, it makes sense to use Dreamweaver
since it is so good at the design side, as well as supporting CF syntax (and a
host of others, as already mentioned).
So for a developer,
Yeah, WYSIWYG is more or less unusable for professional web design because
doing such on a professional level requires intimate involvement in the code
and has to transcend drag-n-drop of simplified components. That being said, I
think the WYSIWYG is good enough in Dreamweaver CS3 to more or
Scott--
The problem is that you are absolutely positioning those three divs (they
aren't rendering correctly in Firefox 2.5 or IE 7, btw). Take off the absolute
positioning, as well as left and top for each. Then, float each left and
use margins to space them out.
This will stop them from
Glad to help!
Joel
Thanks Joel,
Your idea worked :)
sas
--
Scott Stewart
ColdFusion Developer
SSTWebworks
4405 Oakshyre Way
Raleigh, NC. 27616
(919) 874-6229 (home)
(703) 220-2835 (cell)
Scott--
The problem is that you are absolutely positioning those three divs (they
aren't rendering
help that you can provide.
Joel Watson
http://singularityconcepts.com
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Brian--
Thanks for your quick response.
Currently, I am building the XML variable with cfxml, looping over the query
for the appropriate nodes.
I will definitely check out the links you suggested.
Thanks again!
Joel Watson
http://singularityconcepts.com
How are you creating the XML
(string,
arguments.strIn)) /
119 : cfset variables.joBufferedWriter.newLine() /
120 : /cffunction
Now into Java, I am completely out of my knowledge set, so your continuing help
would be greatly appreciated!
Thanks!
Joel Watson
How are you creating the XML variable? Becuase if you are building
Don--
Honestly, I don't think it's bad at all. If I came across it, I would be
confused about the meaning of B T V, but would probably assume that the icon
represented something to do with community or something similar to that.
My $.02~
My apology for OT. Need an opinion, when you see the
Hi:
Dreamweaver is the best html/cfm editor I have ever used. I wonder if there
is a good one for AJAX? Do you know one? If it has some visual tools like
the ones in DW.
Thanks
Ali
For my money (well, actually, it's absolutely free), you can't beat Aptana.
Joel
I have a form with auto-generated datefields that are vertically aligned on top
of one another. In IE7, the div holding the javascript generated calendar gets
displayed underneath the form field items directly below it. Does anyone have
any ideas about how to fix this? I am currently using a
I have three tables, worship_songs, worship_sets, worship_song_lists.
worship_songs:
worship_songID
worship_song_title
worship_song_lyrics
worship_sets:
worship_setID
worship_set_title
worship_set_date
worship_song_lists:
worship_song_listID
worship_songID_fk
worship_setID_fk
I have a spry
Hi guys im trying to create a system where the user has a list of
products and they also have the facility of adding a picture of the
product to its details. i have got everything working apart from the
image upload section. my old upload code requires the user to open a
new window and
I am sorry to keep asking these questions, but I have found a lot of helpful
suggestions from this community, so this is where I turn!
I have a rather involved user survey that collects a variety of information,
including age gender, education levels, and so on. On some of the survey
I have a profile form that has about 7 drop-down menus (marital status,
education level, etc.), all required fields.
How do most handle this? Do you create a separate table for each collection
and then have foreign keys on the profile table, or do you simply pass in
literal values to the
Joel,
if you want to have your database relational to 3rd normal form then yes you
should have separate tables for all of your lookups. Databases are designed
to work well with joins of that nature and if you build your indexes
correctly you should be ok. A lot of people forget to add indexes
Actually, I have one more database question. I have a section on my
profile-collection form that is a series of radio buttons for
hobbies/interests. What would be the best way to manage/store these values?
My initial thought was to create a table with a row for every hobby/interest
item.
On 9/18/07, Joel Watson [EMAIL PROTECTED] wrote:
My initial thought was to create a table with a row for every
hobby/interest item. Then, on the profile table, I was thinking of
having a column that would collect a list of comma delimited values
from the form, from 1 to the number
you can create a middle table between the two that has 1 profile key
and 1 hobby key per row. Each profile could have multiple hobbies.
This would keep you away from the 'dreaded' comma dilimited list in a
table cell.
William
-Original Message
-From: [EMAIL PROTECTED]
-Date: Sep 18,
Scenario
3 tables
Profile table
-kpProfileID
profile_hobby table
-kfProfileID
-kfHobbyID
Hobby Table
-kpHobbyID
The Profile table would have as many rows in it as you have customers
The profile_hobby table would have: 1 row per hobby selected in each
profile
The Hobby table would have 20
On 9/18/07, Joel Watson [EMAIL PROTECTED] wrote:
So let's say that my form has 20 hobbies/interests. I would be
creating 20 entries in this middle table, correct? Is this going to
create a problem if I have hundreds of users?
Since you're only storing profile IDs and hobby IDs
Book by Ben Forta... and others. ;)
Who else helped write it? (haha)
~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
I believe the question related to the CPU usage at the time - if you
watch the CPU stats, what happens when a flash form is requested?
--
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
I don't know that this will be a lot of help, but I received that error
I have an involved flash form that I update using getURL() and Spry's
loadURL() to update database records without page refreshing. Part of
this form is a datagrid which binds its data to the user form.
Is there a way, on a javascript callback event from the Spry loadURL(),
to also
I have an involved flash form that I update using getURL() and Spry's loadURL()
to update database records without page refreshing. Part of this form is a
datagrid which binds its data to the user form.
Is there a way, on a javascript callback event from the Spry loadURL(), to also
refresh
I have the need for a slideshow application. My needs are pretty
basic. It needs to:
Have the ability to have n number of images.
Have the ability to have captions that will go with said images.
Have the ability for the end-user to administrate, create new
slideshows, upload
Well, that's the thing: I don't have a particular scenario in mind. I'm
looking more for conceptual and methodological ideas, e.g., the user has
submitted the form: now what?.
But perhaps to get it started, let's say I have a registration form with the
following fields:
Name:
Username:
Does anybody have or know of a good resource for validation routines on data,
specifically form data? What I'm looking for is an outline of the various
checks that one would perform on data to ensure it is valid, in the right
format, etc.
I realize this request is extremely broad, so my
Hi there
I have a query where I am getting information from 2 tables.
Basically a category table i.e. categories are face, body breasts
Users have entered details of cosmetic enhancementprocedures according
to whether the procedure is for face, body or breasts, e.g. face has
face
If all your photos will have prices you won't need to left join you can
just join on them.
Joel Watson wrote:
That's true, but when I combine it with the LEFT OUTER JOIN on the comments, it
screws up the comments. While it will return the prices information fine, it
duplicates
If all your photos will have prices you won't need to left join you
can
just join on them.
Joel Watson wrote:
That's true, but when I combine it with the LEFT OUTER JOIN on the
comments, it screws up the comments. While it will return the prices
information fine
I have two tables, photos and comments. Their structures are as follows:
photos table
--
photoID
photoTitle
comments table
--
commentID
commentText
photoID_fk
I need to write a query that will allow me to display all the records in photos
while also displaying
First write your sql as
SELECT p.photoID, p.photoTitle, c.commentId, c.commentText
FROMphotos p
LEFT OUTER JOIN comments c
ON c.photoid_fk = p.photoid
ORDER BY p.photoID, c.commentID
Then output the query using cfoutput and group like this
ul
cfoutput
First write your sql as
SELECT p.photoID, p.photoTitle, c.commentId, c.commentText
FROMphotos p
LEFT OUTER JOIN comments c
ON c.photoid_fk = p.photoid
ORDER BY p.photoID, c.commentID
Then output the query using cfoutput and group like this
ul
cfoutput
Joe,
First of all I am not sure if you need LEFT JOIN for both comments and
prices. My first example was based on the assumption that you could have
photos without comments and you might want to display those as well.
It will help if you can paste the entire query and your output code.
Thanks
I am trying to use a CFFORM format=Flash tag that has multiple tabs.
I want the user to be able to enter information on the first tab, and
then by clicking on the second tab, have the data available. I
thought that this was a relatively simple request, but I cannot seem
to get the
I have a simple two field form that I would like to submit to a database
without doing a postback on the page.
Is there a way to use javascript to invoke my component?
Obviously, CF8 will make this ridiculously simple for people like me who are
idiots at javascript. However, until that
you'd need the onclick to call a function that triggers tha AJAX call.
I've found JSMX to be a very nice lightweight library for AJAX, and i
think it'd work well for you here (you don't need all the bells and
whistles of a jQuery or YUI or Prototype etc for this specific task).
i usually debug the AJAX stuff with the Firebug plugin for Firefox.
Got that loaded up? If not, you should (not just for this... but in
general, it's a must-have).
--
Charlie Griefer
...All the world shall be your enemy, Prince with a Thousand
I have a table that contains user and station information, as well as a boolean
field for whether the information is displayed or not.
It looks roughly like this:
uStationID
userID_fk
stationID_fk
checked
I have another very similar table that looks like this
cStationID
customerID_fk
As an illustration, say that users table has the following entries:
userID_fk [1]
stationID_fk [4]
checked [0]
So here, the query will return only the value of the second and
forth
row.
The forth row isn't checked. I'm assuming that's just a typo.
If I'm
Is there a way to access certain attributes of a cookie, such as the creation
and expiration dates?
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build powerful, scalable RIAs. Free Trial
I have a flash form select field that is supposed to populate with the titles
of some blog posts. I have tested the query and it works as expected.
However, when it is used in the flash form select, it does not display.
What is most weird about this is that it works as expected on my local
Not really used the flash forms myself. But the one thing that is a must is
that virtual mapping in the IIS for /cfide...
On 6/10/07, Joel Watson [EMAIL PROTECTED] wrote:
Would that affect the query display? The forms themselves are compiling fine,
they just will not display the queries
I recently found out that I need to allow users to upload files from their
browsers to another, non-coldfusionized server. I am assuming that cfftp is
the solution for this.
My question is this: is it possible to use cfftp to transfer files directly
from the client browser to the ftp server,
Yeah, I am using that to get to the cffile variables.
You will need input type=file... to upload the file to the CF Server,
not cffile. Remember that cf tags run on the server, clients have no access
to them.
-Original Message-
From: Joel Watson [mailto:[EMAIL PROTECTED]
Sent: Friday
Jun 2007, Joel Watson wrote:
My question is this: is it possible to use cfftp to transfer files
directly
from the client browser to the ftp server
Where does CFFTP run :-)
If you could control the client, you could have them run an FTP server
though,
for instance.
1. Use cffile
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 3:35 PM
Subject: Drink Coffee - What's Ray talking about?
http://ray.camdenfamily.com/index.cfm/2007/5/29/Drink-Coffee
I thought it was that he just had a lot of work to do and wanted to
I have a site where the user logged in state is managed through a cookie
created from a remember me form. It seems to work fine.
The one problem I have, though, is that the cookie is active or acted-upon only
if the user is pointing to the http://www.mysite.com and not the
http://mysite.com.
Awesome--that worked. I had seen that in the docs before, but I was not
particularly sure what it was referring to. Thanks for the clarification!
You need to set a domain cookie for mysite.com.
http://livedocs.adobe.com/coldfusion/7/htmldocs/0233.htm
On 5/28/07, Joel Watson [EMAIL
expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Scott Stroz
To: CF-Talk
Sent: Wed May 23 22:45:46 2007
Subject: Re: CFDirectory Help
Shot in the dark:
cfif NOT DirectoryExists(root\#FORM.username#)
On 5/23/07, Joel Watson [EMAIL PROTECTED
I have an upload form that writes files to directories which have the same name
as the users uploading the files.
I want to be able to check and see if the directory exists after the upload
form is submitted, and if it does not exist, create it and then upload the file
to it.
Right now, I
I have a forum in which users can subscribe to particular threads. When other
users make replies, all users who are subscribed to the thread will receive an
email (basic stuff, I know).
My question is regarding what the best practice for handling this mailing
should be.
Currently, I am
At the moment, I'm on Godaddy shared, so I'm not sure. However, I am going to
be going the dedicated route soon and will be using mx7.
You don't need to delay the emails anymore... What version of CF are you
using?
On 5/11/07, Joel Watson [EMAIL PROTECTED] wrote
heavy etc.
Sorry for the rushed response.
HTH Jose Diaz
On 5/11/07, Joel Watson [EMAIL PROTECTED] wrote:
~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http
not to day that you might not
with a cfloop either, but at least the emails when spooled will not go
unless the server is idle reducing the time between emails being sent out.
On 5/11/07, Joel Watson [EMAIL PROTECTED] wrote
but it can happen...
Same as multiple email address in the fields can also be flagged as being
spam as well.
On 5/11/07, Joel Watson [EMAIL PROTECTED] wrote:
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration
ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Joel Watson [mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 10:39 AM
To: CF-Talk
Subject: Add Together Values of Dyanamic Fields
I have a form in which several
For the date format, add a simple mask:
cfinput type=datefield label=Date Received name=daterecdrequired=Yes
size=10 maxlength=10 message=Please enter the date theapplication was
received validate=date validateat=onsubmit,onServer mask=dd/mm/
You will, of course, still want to be sure it's
Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Joel Watson [mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 10:39 AM
To: CF-Talk
Subject: Add Together Values of Dyanamic Fields
I have a form in which several of the fields are generated
In your INSERT statement, access the name of the file from your upload
statement using #cffile.Serverfile#.
Ex:
cfif isDefined(FORM.submit)
cffile.
cfquery datasource=mydb
INSERT INTO products (imagepath)
VALUES (
'#cffile.Serverfile#'
)
/cfquery
Obviously, you will want
I have a forum that automatically emails topic replies to subscribers.
However, I am having a difficult time getting the text to display properly. I
have tried a number of code cleaning functions, but the end result is all the
same. Is there something special I have to do to get special
I have a form in which several of the fields are generated dynamically based on
the choice of the user.
I would like to be able to somehow grab the entered values of the fields
(client-side) and add them together into another field before the form is
submitted. I realize that technically this
I am trying to make a search display page that will display a snippet of text
(about 300 characters) from blog posts that match the search criterion.
I have no problem with generating the results, but I would like to be able to
zero in on the actual search term within the returned query.
So,
I wouldn't know how to layout a page in tables if I had to...css rocks, with
the obvious and glaring exception of IE 6.
Looking forward to it!
I've looked into using CSS for layout, but it seemed to be
a pain in the rear trying to accommodate all the different
browsers, so I just stuck with
I am doing a very, very simple search on two database columns, Title and
Link.
For my query, I am also doing the simplistic:
cfquery name=Search datasource=mydb
SELECT * FROM my_table
WHERE 0=0 AND
Title LIKE '%#FORM.SearchText#%' OR
Link LIKE '%#FORM.SearchText#%'
/cfquery
On the output, I
Well, it turns out that the casing of the fieldnames was the problem. I didn't
realize that this was an issue for IE (and I don't quite understand why it
would be). Anyway, it works, so that is enough.
Thanks for your help, and yes, I am going to add the cfqueryparam on the
final go.
Thanks!
Thanks, this works great!
I really appreciate your help, as well as the responses from everyone else!
Joel
Here you go Joel, I got this code from someone else long ago, and now am
passing it on to you. =) You may store other data about them, but you
can go from here.
cfapplication
I have a site (a forum, really) that allows users to login and post messages.
Is there a way that I can display the number of users that are currently logged
in?
Thanks!
~|
Deploy Web Applications Quickly across the
I am getting ready to launch a blog/forum that I have designed and developed.
However, I am having a bit of trouble with the text formatting/output.
What are some best practices for inserting clean code into the database (mySQL
5.0), writing inserted data to XML-compliant formats, etc.? I am
Can somebody tell me what's wrong with this code?
I have a podcast that uses exactly the same format (with different tags,
obviously) and works fine. With this one, however, I am simply trying to
create a basic feed and I continue to get this error:
An error occured while Parsing an XML
[#Post.PostContent#]]/description
I prefer the latter simply because it's native XML and doesn't perform
any conversion of my data. Either should work perfectly well, though.
On 4/6/07, Joel Watson [EMAIL PROTECTED] wrote:
~|
Deploy Web
I'm really new to xml---
Where exactly are you doing this cleaning?
An invalid XML character (Unicode: 0x1c) was found in the CDATA section.
Here is a regex I use to clean my xml of any funky characters:
cfset newxml = rereplace(oldxml, [\x00-\x1f], , All)
Then you should probably still
example is
oldxml. For example:
cfsavecontent variable=oldxml
cfoutput query=myquery
item#item#/item
/cfoutput
/cfsavecontent
Then you clean the string oldxml and then wrap it with the cfxml tag.
-- Josh
- Original Message -
From: Joel Watson [EMAIL PROTECTED]
To: CF
This is probably a stupid question, but I have no pride.
Consider the Adobe Forums. Let's say I login to the forums on my computer at
work. Now, let's say I close my browser, go home, call in sick the next day,
and return to the office a day later. When I return to the Adobe Forums on the
, page_9, etc.). You can loop over the
formfields list and extract them.
Sorry if that's not clear, but I'm pretty tired. :-)
--Ben
Joel Watson wrote:
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10
can loop over the
formfields list and extract them.
Sorry if that's not clear, but I'm pretty tired. :-)
--Ben
Joel Watson wrote:
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http
I recently bought a new computer, including (Duhn, Duhn, Duh...) Windows Vista.
While I had no trouble at all setting up Coldfusion, nor in connecting my
local sites to it and databases, I have noticed some considerable slowdown
between the loading times on my new PC and my XP-PC at work (both
. If Apple would fix
that, it would be a no-brainer.
Upgrade to OS X
MD
On 28 Mar 2007, at 17:13, Joel Watson wrote:
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com
I am attempting to modify a flash form that I downloaded off of ASFusion.
Currently, my upload file (uploadimage.cfm) is in a folder called
upload-image which is one level off the root. I want to be able to upload
the images to a folder called images within the upload-image folder.
Thanks to everyone for the input. Actually, I had tried the './images'
before--as it turns out, I missed something in the action scripting that had
the filefield pointing to an entirely different file that contained simply the
'.'--DOH! A quick change on that file to your suggestions solved
I have a fairly complex problem I am trying to solve.
I have a form for creating sponsors. On this form, the user is given a series
of checkboxes for selecting which page(s) they would like the sponsor's
advertisement to display. On submission, the selected check boxes are written
to a list
Thanks for the response. One of the issues I am running into is that (and I
failed to mention this in my original post) the checkboxes are being
dynamically generated from another table called Pages. So then, for whatever
reason, my list is being written with values for every checkbox,
Ben, Dinner--
Thank you both for the erudite responses. You have convinced me!
Now for the million-dollar question:
As mentioned, I am generating the select boxes dynamically from the Pages
table. If I am to enter the users inputs from the check boxes, how would I go
about parsing out these
In your insert statement, reference the FORM.eqImage field for your dbase
entry and use '#cffile.serverFile#. This will grab the name of the file (in
this case, the image) that you have uploaded to your server. cffile.clientfile
also works, but this will only get the name of what the user
I have a two tables, Questions and Answers. I am wanting to create a cfform
that will allow me to easily allow for users to create questions, and then
assign answer options to these questions.
Using the cfgrid edit functionality, I have created the question-creation
side no problem. However,
I have a cfform that is dynamically populated with test questions and answer
choices from a database. The answer choices are also dynamically named based
upon the id of the question, e.g., input name=Q#QuestionID#. I am currently
able, upon submit, to pass the values of user-selected answers,
?
www.bennadel.com/ask-ben/
-Original Message-
From: Joel Watson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 06, 2007 7:37 AM
To: CF-Talk
Subject: Insert Looped Form Entry into Database
I have a cfform that is dynamically populated with test questions and
answer choices from a database. The answer
1 - 100 of 105 matches
Mail list logo