Create two data tables, one for terms (have an term_ID and search_term
field) and one for search date/time (have a term_ID and date/time field).
I know little about db design, sorry: why would you use 2 tables rather than
one with 3 columns?
Sure it's helpful. I want to know how many times
Hi there,
What do you mean by peg? If you mean crash or bottle neck than the answers no
because this issue happens 24/7.
Any other ideas would be great!
Cheers
Matthew
Does your server peg temporarily around the same time?
Respectfully,
Adam Phillip Churvis
Get advanced intensive
Make Sure you have the Fields set as Fulltext
Eric
On 8/23/07, Les Mizzell [EMAIL PROTECTED] wrote:
We use MS SQL and utilize full text queries just like any other select
query. I suspect that MySQL will work the same.
So the below should be a valid query then?
cfquery
SELECT
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?
On 8/24/07, Matthew Chambers [EMAIL PROTECTED] wrote:
Hi there,
What do you mean by peg? If you mean crash or bottle neck than the answers
no because this
[EMAIL PROTECTED] wrote:
If someone has a link structure on their site of ...
www.site.com/omapps/ContentServer?cid=1058290118806pagename=InvestorRelations%2FPage%2FIR_Standardc=Page
What application platform is this?
Look at the HTTP headers.
Jochem
Actually, I wrote an article about this for CFDJ, which includes code for a
cfc that reports on search terms, auto-mails a weekly (or other period)
report, etc.:
http://cfdj.sys-con.com/read/48234.htm
I'll take a look, thanks for the tip!
Just have one table, do not worry about the size of the table, it's
negligible. If it's a site that requires a login, save their login id,
the search term and the date (it does not matter if you intend on
using it now, you might later). You do not need a counter, you can
count using the SQL query.
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
We often create a folder in our application root that contains all
components used for the application. We then create a mapping to that folder
so that we can invoke components from anywhere within the application.
Not happy with this approach (prefer an application that just works when it
moves
On second thoughts, although it does work, I think it would be better to
place the code into a file and save that file in the directory where your
components live. Then you just get:
cffunction name=GetComponent returntype=any hint=Returns the results of
a given CFC method call
cfargument
I just create 1 mapping, usually COM, then place things in sub-dirs
based on where they came from, and further directories by function.
Works good for me, and only 1 mapping.
Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer
-Original Message-
From: Dominic Watson
Does anyone know of an easy way to create custom folders for fckeditor? For
example the default image folder is
/Image
Default file folder
/File
Is there no easy way to customize these folders? my default image folder
should be images/images my default file folder should be /documents.
I have
Java style packaging can solves this. Simply map COM and then you can have
component paths similar to:
com.mysite.util.StringUtil
com.mysite.commerce.CommerceUtil
com.shared.util.StringUtil
com.myOtherSite.commerce.SomeOtherComponent
HTH,
Rich
Do you create a COM mapping the same way as any other, i.e. in Coldfusion
administrator? We use hosting and never have access to these things.
The only mapping we usually create is the component path one. So, with the
little function, there are no mappings at all.
Thanks,
Dominic
On
I'm building a link generator tool that creates links to data driven
glossaries. The theory is the user can cut and paste the link into either
static text on the site, or into text areas on forms to update the data
base. I can handle the quotes, but the #'s are giving me a fit.
I can output a
Can anybody point out still existing documentation that describes what
registry settings one plays with to reset the administrator password for
CF4.5?
TIA
Ian Skinner
~|
Download the latest ColdFusion 8 utilities including
We do also 'package' the components by creating subfolders withing our
components folder where neccessary. Is this what you mean?
Apologies for the multiple post and thanks again,
Dominic
~|
Enterprise web applications, build
I have a shared hosting account with GoDaddy and a domain of
myrootdomain.com. Under the root I had a subfolder to which
I pointed another domain (mysubdomain.com). In the subfolder
I had a flash form.
When I would browse to the flash form like so:
Can anybody point out still existing documentation that
describes what registry settings one plays with to reset the
administrator password for CF4.5?
I don't have any documentation handy, but it's in the vicinity of
HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion. It should be pretty easy
This works fine when it's going into HTML text, but when it's
going into a cf form, the # throws off Cold Fusion. If I use
a breaking ##, that work for cf handling, but isn't right for
HTML text.
I'm not sure what you mean by a breaking ##, but if you simply use two
hashes instead of one
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
if you simply use two hashes instead of one within your CFOUTPUT
It's a little more complicated. It can be pasted into a form, which updates
a data base that is queried for later output, or it can be pasted straight
into HTML static copy. It needs to work for both.
I think I've solved it by
Sounds like he's also outputting this straight to HTML as well though.
My suggestion is to completely abstract the linking with javascript. For
example, on my family blog I've got a js function which allows me to use
plain ole HREF links:
a href=slideshow.cfm?slide=58gid=19
IIRC, you can return false in the JS call to fix this problem. But
that's a vague memory from years ago.
--Ben Doom
Robert Harrison wrote:
I'm building a link generator tool that creates links to data driven
glossaries. The theory is the user can cut and paste the link into either
static
How would I replace the carriage returns in a textarea entry with br?
~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
Here's another option. If I just use
a onclick=domyactionThis Term/a
That functions almost right. It doesn't move the base page, still does the
action, creates a link, eliminates the # issue, etc.
What it doesn't do is give me the cursor arrow on mouseover. I'm going to
look for a way
#replace(myTextAreaText, '#chr(13)chr(10)#', 'br /', 'all')#
On 8/24/07, Matthew Smith [EMAIL PROTECTED] wrote:
How would I replace the carriage returns in a textarea entry with br?
~|
ColdFusion 8 - Build next generation
How would I replace the carriage returns in a textarea entry with br?
cfset
newstring='#REREPLACE(#REREPLACE(#Trim(form.mystring)#,quot;,,all
)#,#chr(13)#,br,all)#'
This will do carriage returns and quotes to you can pass the data around in
forms. Keep in mind, however, if you stick br into a DB
For what it's worth I usually replace tabs with 5 spaces at the same
time.
Also, sometimes only a line feed is present with no carriage return, so
I will replace carriage return/line feed combinations first, and then
replace any remaining solitary line feeds.
replacenocase(text,chr(13)chr(10),br
Thank you, Robert. Exactly what I needed.
-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED]
Sent: Friday, August 24, 2007 11:42 AM
To: CF-Talk
Subject: RE: replace carriage returns
How would I replace the carriage returns in a textarea entry with br?
cfset
Do you create a COM mapping the same way as any other, i.e. in Coldfusion
administrator? We use hosting and never have access to these things.
Sorry, I meant to create one mapping to the com folder, and package your
other components under it.
We do also 'package' the components by creating
If you go that route, I'd offer up the suggestion of cleaning up the
extra # signs a bit.
cfset newstring =
rereplace(rereplace(trim(form.mystring),quot;,,
all),#chr(13)#,br,all) /
just makes it a bit more readable (IMO). and also God kills a kitty
every time you overuse pound signs :)
FWIW,
Problem solved. The trick was to get rid of the href altogether. This string
works in all browsers and passes around fine in CF and DBs or static HTML.
a
onclick=openPopUp('http://myurl.com/glossary.cfm?glossary=1term=2','glossa
ry','410','300','110','35') style=cursor: pointer;This Term /a
Of
Ok, to make it a bit more difficult... :)
How would I ignore inserting carriage returns is the carriage return
comes after a ul, li, /li, or /ul?
This is so that the site owner can edit the text on the front page of
the website themselves. There is a ul in the current text.
Thanks!
and also God kills a kitty every time you overuse pound signs :)
E. Man, I knew there was a reason I worked so hard to get those # signs
out of my glossary link.
Robert B. Harrison
Director of Interactive services
Austin Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T :
How would I ignore inserting carriage returns is the carriage return
comes after a ul, li, /li, or /ul?
If you're letting them enter HTML code, make them enter HTML with their own
p tags and br /'s. Either you control it or they write html. It would be
a nightmare to mix the two.
Robert B.
you should probably start looking at FCKEditor or TinyMCE or the like.
You're recreating the wheel here.
On 8/24/07, Matthew Smith [EMAIL PROTECTED] wrote:
Ok, to make it a bit more difficult... :)
How would I ignore inserting carriage returns is the carriage return
comes after a ul, li,
Installed Saw the Adobe technote on installing it too. Seems to work.
Now I am trying to match the encryption results to my expected results. They
are different. I am guessing it a matter of getting apples to apples at this
time and it probably has to do with key length or something... Cast5
You missed one.
Wouldn't want to doom any kitten today :)
rereplace(rereplace(trim(form.mystring),quot;,,all),chr(13),b
r,all)
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Friday, August 24, 2007 12:00 PM
To: CF-Talk
Subject: Re: replace carriage returns
I have several virtual hosts set up, one for each site. When I try to
log into the admin section, which uses a client variable to set log in
status, I just keep getting the log in page even after putting in the
correct password.
The login portion of code is simple:
cfset client.adminloggedin =
Is there a problem with client variables if you are using
virtual hosts?
No. However, you may have some generic problem with cookies due to a
misconfiguration of some sort.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber
Are you using sub-domains? It could be a problem with domain cookies.
Look in your debugging info or dump the client scope to determine if the
adminloggedin variable is really getting set the way you expect.
~Brad
-Original Message-
From: Matthew Smith [mailto:[EMAIL PROTECTED]
Sent:
Can anybody point out still existing documentation that describes what
registry settings one plays with to reset the administrator password for
CF4.5?
TIA
Ian Skinner
My goodness. When I saw this thread, I figured it was a Rick Faircloth post.
But I think he's CF4. :)
The trick here is CF's list functions don't register empty list spots.
If you do a ListLen on 1,2,,3 which looks like four spots - it'll
return 3.
I tend to do a Replace() on strings like that - set ,, to , , -
adding a space - and then that way, the list functions will sniff out
that
Why not use dts? Put the work on the db server, not the cf server. MUCH
faster too.
-Original Message-
From: Steve Sequenzia [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: 8/24/07 2:32 PM
Subject: Importing CSV into
I am trying to write some code that takes a .csv file
Oh and something I forgot - you'll need to accomodate rows like you
mentioned in your example, where what should be the first or last list
positions are empty as well. Something like
cfif left(string, 1) IS ,
cfset string = ' ' string
/cfif
so as to put something (even just a space) in
I am trying to write some code that takes a .csv file and inserts it into SQL.
I am having issues with it reading the header. I would like to be able to leave
the header on the file and not have it insert the header data into the DB.
When I try to run it without a header I am having issues with
I had the need to do this just yesterday. Hacking the files under
filemanager/browser/default/connectors/cfm (config.cfm and connector.cfm) as
well as filemanager/upload/cfm (config.cfm and upload.cfm) was the ONLY way I
could figure out how to do it.
Just remember to add this to both config
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have done this same exact thing using Coldfusion and Flash
Comminication Server which can be viewed at
http://ipvideo.niesc.k12.in.us and if you click on Plymouth Community
Schools you would be able to hear the Live Football Broadcast at
7:30PM EDT
I have a rather deeply nested structure set which at one level has an array
in it. I am trying to test that a value is defined with the following code:
isDefined('base.dataSets.user.dataElements.firstName.assertions[1].assertId'
)
However, I am getting the following error message:
Dan, sorry, I may have misunderstood your question.
Are you saying you want two separate folders in your root, or two separate
folders within the same directory?
The solution I posted is for the latter ... FCKEditor wants all your stuff in
one default folder off the root. Then that default
CF4! Not! I'm up to CF4.5! So there! :o)
Rick
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Friday, August 24, 2007 3:37 PM
To: CF-Talk
Subject: Re: Reset Administrator Password for version 4.5
Can anybody point out still existing documentation that
So the below should be a valid query then?
{deleted for brevity}
I am unfamiliar with the syntax of MySQL full text queries so I can not be
definite however this MSSQL full text query works just fine.
cfquery
SELECT (KEY_TBL.RANK * 1000) AS RANK, field1, field2
FROM myTable AS
I am trying to upgrade from CF7 to CF8 standard. I get all the way through
the install process and it stays on Installing Web Server Connectors
forever. I let it run for a few hours even to try it. So I have to kill the
process. I then try it again and it will go all the way through but I get a
This should work for you:
structKeyExists(base.dataSets.user.dataElements.firstName.assertions[1],'assertId')
Jake Pilgrim
~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and
I am trying to upgrade from CF7 to CF8 standard. I get all the way
through
the install process and it stays on Installing Web Server Connectors
forever.
I've noticed a problem when importing the DNS: the DNS is installed
correctly, but the system seems to wait indefinitely,
until a time limit
It does and it gets me around the issue, I just don't get why isDefined would
say that is not a syntactically correct variable name.
Thanks
-- Jeff
This should work for you:
structKeyExists(base.dataSets.user.dataElements.firstName.assertions[1],'assertId')
Jake Pilgrim
I forget how to do this. ReturnedZIPs is a variable with comma delimted zip
codes.
I tried valuelist and got an error. Any help would be great thanks.
cfquery name=get_stores datasource=#datasource#
select *
from tblstores_import
where zip IN ('#ReturnedZIPs#')
/cfquery
Assuming zip in the database is number field then it should work without the
single quotes around the variable. I would use a cfqueryparam though:
WHERE ZIP IN (cfqueryparam value=#Variables.ReturnedZIPS#
cfsqltype=cf_sql_numeric list=yes /)
On 8/24/07, [EMAIL PROTECTED] [EMAIL PROTECTED]
I forget how to do this. ReturnedZIPs is a variable
with comma delimted zip codes.
where zip IN (#preserveSingleQuotes(listQualify(ReturnedZIPs, '))#)
Not tested, but should either work or get you on the right track.
-Justin Scott
WHERE zip IN (#listQualify(returnedZips, ')#)
that second argument of listQualify is a single quote enclosed by double quotes.
On 8/24/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I forget how to do this. ReturnedZIPs is a variable with comma delimted zip
codes.
I tried valuelist and got
It does and it gets me around the issue, I just don't get why
isDefined would say that is not a syntactically correct variable
name.
An array member is not a variable. The array itself is the variable.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides
ooh that's better than mine. cfqueryparam for the win.
On 8/24/07, Aaron Rouse [EMAIL PROTECTED] wrote:
Assuming zip in the database is number field then it should work without the
single quotes around the variable. I would use a cfqueryparam though:
WHERE ZIP IN (cfqueryparam
Using the list function with CSV files can be an issue since the List
stuff in CF doesn't recognize a blank column. So Something,,, only
returns 1 element.
The other thing is that excel does weird things with CSV files also.
There is a really nice java library called Ostermiller
Okay, I guess that is an obvious enough answer. Is it quiting time yet?
Thanks.
-- Jeff
It does and it gets me around the issue, I just don't get why
isDefined would say that is not a syntactically correct variable
name.
An array member is not a variable. The array itself is the variable.
Hey guys,
I am having huge difficulty figuring this out. I am trying to get cfgrid to
work with bind attriute, along with format=html. I am trying to pass some
values to the function (name: get2) along with the required cfgridpage,
cfgridpagesize, cfgridsortcolumn, cfgridsortdirection (code
Are all the values null or only your custom ones?
On 8/24/07, Jaysheel Bhavsar [EMAIL PROTECTED] wrote:
Hey guys,
I am having huge difficulty figuring this out. I am trying to get cfgrid
to work with bind attriute, along with format=html. I am trying to pass some
values to the function
i could not get that to work with named attributes myself... i wound up
doing it ordered.
-jim
On 8/24/07, Jaysheel Bhavsar [EMAIL PROTECTED] wrote:
Hey guys,
I am having huge difficulty figuring this out. I am trying to get
cfgrid to work with bind attriute, along with format=html. I
Since I know we have a few Model Glue gurus here...I need to learn it
for an upcoming project at work. Can an of you all suggest some books
and other resources that are good? Thanks in advance.
Eric
~|
Download the latest
Here is ColdFusion and Fusebox news
* CFUNITED/Express Chicago (aka CF_Underground) early bird ends 8/31/07
* CFUNITED/Europe-08 call for speakers ends 8/24/07
* Adobe's Damon Cooper on ColdFusion 8 and CFUNITED
* CFUNITED podcasts - Simon Horwith - Object Think - Common Sense
Software
there's a web site. with forums. and a mailing list.
http://model-glue.com/
http://model-glue.com/forums/
http://groups.google.com/group/model-glue
altho the forums aren't looking too terribly popular :)
On 8/24/07, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Since I know we have a few Model
- permitinfo
- permit
- permitdetail
statusApproved/status
areanameNorthern Utah/areaname
descriptionGarage/description
numberHON07032905/number
date03/29/2007/date
value22000/value
/permitdetail
/permit
- permit
- permitdetail
statusApproved/status
areanameNorthern
Can I gind a cfdiv to a query so that the div area will only show if
there are query results. I want to bind it to a select box for
instance.
So if I choose a value from the select dropdown, then the div shows my
nicely formatted cfoutput block with query results inside.
I could pull in a
In excel, you get a prompt: the specified xml source does not
refer to a schema. Excel will create a schema based on the
xml source data.
Can I somewho provide that schema automatically?
Sure:
permitinfo xmlns:xsi= http://www.w3.org/2001/XMLSchema-instance;
Dave, THank you. That is what I was looking for. I think I can
figure it out from here. I need to learn xslt and all that, but I was
stuck trying to figure out how to get that info in there using the
CFXML tag. Easy as inserting it in my root element as per your
example.
Thanks again, off to
i could not get that to work with named attributes myself... i wound up
doing it ordered.
-jim
Hey Jim, I am not sure what you mean by this.
~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from
Yes, all my values were null, and for some reason one of the values passed
showed more null values than what should have been there. So I changed all the
variable names used in cfgrid tag. Now I don't get any error messages, but I
don't get anything at all. Its just an empty grid. I ran the
riaforge.org is down for me and I'm after a copy of the latest Transfer
files, can anyone help out or point to an alternate download?
Thanks.
Adrian
~|
ColdFusion is delivering applications solutions at at top companies
Adrian,
Have you tried exporting from SVN:
http://svn.riaforge.org/transfer
It may work?
Mark
On 8/25/07, Adrian Lynch [EMAIL PROTECTED] wrote:
riaforge.org is down for me and I'm after a copy of the latest Transfer
files, can anyone help out or point to an alternate download?
Thanks.
You seriously just keep adding row upon (duplicate) row every day for years and
years? That's a hell of a lot of rows because people search a lot. I'm
surprised, but I'm no expert. If no one thinks that's a bad idea...
Thanks again.
Cheers Mark, but still no luck.
Can anyone else not see riaforge.org in anyway?
-Original Message-
From: Mark Mandel [mailto:[EMAIL PROTECTED]
Sent: 25 August 2007 02:13
To: CF-Talk
Subject: Re: Transfer Download
Adrian,
Have you tried exporting from SVN:
Yes, but the rows are not (duplicate).
The time, the search string. Potentially the IP address. in
combination, always unique.
On 8/24/07, stylo stylo [EMAIL PROTECTED] wrote:
You seriously just keep adding row upon (duplicate) row every day for years
and years? That's a hell of a lot of rows
It is coming up for me.
On 8/24/07, Adrian Lynch [EMAIL PROTECTED] wrote:
Cheers Mark, but still no luck.
Can anyone else not see riaforge.org in anyway?
-Original Message-
From: Mark Mandel [mailto:[EMAIL PROTECTED]
Sent: 25 August 2007 02:13
To: CF-Talk
Subject: Re: Transfer
Yup, it's back up for me too. Just got sent some files also. Thanks all.
Adrian
-Original Message-
From: Aaron Rouse
Sent: 25 August 2007 03:19
To: CF-Talk
Subject: Re: Transfer Download
It is coming up for me.
On 8/24/07, Adrian Lynch [EMAIL PROTECTED] wrote:
Cheers Mark, but still
Hello,
I need to import a large 2 megs or so 271 EDI file into sql tables. EDI files
are not fun to parse, but I have it working fine. The problem is speed. It is
slow to me... 61 sec to parse 80k file (171 records).
Any ideas on how to improve it? This will be moved to a hosted site, I
oi... HIPAA docs. Good luck with that. Honestly, you'd likely be
better off using GenTran, EXTOL, Sterling, whatever to do your
translation. But then, I used to work with the EXTOL team, so I'm
biased ;). I interviewed for a job in Pittsburgh for Northrop that
used CF to manage several
I'm a little late here, but you could also do
a href=javascript:; onClick=action()link/a
Problem solved. The trick was to get rid of the href altogether. This string
works in all browsers and passes around fine in CF and DBs or static HTML.
a
87 matches
Mail list logo
