Does anyone use an Acess DB with a table that contains
a field type of MEMO?
If so, can you check to see if any data contained there
has more than 255 characters?
Everytime I attempt to enter 300+ characters into the
field I get the error:
invalid precision error
The field type is in fact a
Thanks,
That did it. I was using the normal CF_SQL_VARCHAR
Matt Robertson wrote:
Sure it works fine.
You must use cf_sql_longvarchar as the cfsqltype. cf_sql_clob might
work as well but cf_sql_longvarchar cfsqltype is a gaurantee.
But there is no decimals in this.
Adrian Lynch wrote:
I'm not too hot with Access but if that were SQL Server my first thought
would be to look at decimal datatypes.
Ade
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: 01 April 2005 23:27
To: CF-Talk
Subject: SQL
I know this is MS SQL Server related but for a CF app.
I have a SQL script that creates the following table but produces the
following warning.
Any idea what this means and how I can get around it?
CREATE TABLE [dbo].[FILE_CATEGORY] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[CATEGORY]
Hello,
Some of our Access tables are being moved to our SQL Server, while some remain
in Access.
I have two datasources that separate the SQL from Access. However, I run into
some code
where tables from each of the datasources are in one CFQUERY within a join.
Can I indicate multiple
Here is a question for you Tony, sorry not a resolution for your issue,
when you are dealing with locales as you described, did you do a template
which contains all the language based labels and assigned them as variables
to be used?
such as:
English Template:
varSubmit = Submit
Spanish
Does anyone know what's causing this? I get an error message when I try to save
edited files in DWMX2004.
While executing receiveArguments in File_Save.htm, the following JavaScript
error(s) occurred:
at line 75 of the c:\Program Files|Macromedia\DreamWeaver MX
- The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199658
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com
Has anyone ported VB6 applications to the Web through CF pages?
We have a bunch of Visual Basic v6 applications that need to be ported
to our Web site. Has anyone had any experience do this? I'm the CF developer
and we have another person that is the VB developer. Between the two of us,
we
Does anyone know if it is possible in IIS to create the virtual
directory pointing to
a CFMX 6.1 application under:
CFUSIONMX \ WWWROOT \ THISAPP
Catch is, I also have CF5 co-existing on the machine. and IIS home
directory points to
a folder of wwwroot which is mainly CF5 applications.
I
directory action.
jonese
On Sat, 12 Mar 2005 07:30:59 -0500, ColdFusion Developer
[EMAIL PROTECTED] wrote:
Does anyone know if it is possible in IIS to create the virtual
directory pointing to
a CFMX 6.1 application under:
CFUSIONMX \ WWWROOT \ THISAPP
Catch is, I also have CF5 co-existing
Set the MIME type to unknown
Protoculture wrote:
On some windows machines it gives the user the option to save or open, on
others it opens up in the default application immediatley ( ie, word. Opens
open in a word like interface within the browser ).
How can I force to have the default being
You could use the calculated data set, create a new query
using QueryNew and then do a Query of Queries (QoQ)
and re-sort it that way, then display.
A drawn out process but works.
Les Mizzell wrote:
Page in Question: http://www.cyndustries.com/bugmusic_vote_completed.cfm
(Unless you're into
I do all development for FireFox, then fix the little things from IE and
NetScape.
Thats the only ones I deal with honestly.
Dave Merrill wrote:
I've been doing intranet work for a while now, where the only browser we had
to support was the one that came installed on company PCs. Have recent
CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192495
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http
Using a CF Query to add a record to Oracle, I havea date field to add
When adding it, it is straightforward, right?
When retrieving the date information, I need to do a To_Date function?
Is that correct?
Been a long time since I had to use Oracle.
Thanks, like I said, been a long time since I used it.
By chance any website you may have I can reference for more
questions like this?
Thanks again!
James Holmes wrote:
INSERT / UPDATE with to_date()
SELECT with to_char()
-Original Message-
From: ColdFusion Developer [mailto:[EMAIL
Is anyone using Cardservices (aka. LinkPoint) to process
credit card sales on their website?
I am trying to set things up and would like some more information
that the API manual does not provide.
Thanks!
~|
Logware: a new and
I am working on a script that will dynamically determine where
a directory is located within an application.
Lets say the structure is as follows:
D:\www\myApp\
D:\www\myApp\admin
D:\www\myApp\admin\profile
D:\www\myApp\images
D:\www\myApp\includes
D:\www\myApp\users
D:\www\myApp\users\profile
All,
I have one question. Any direction would be great.
1) Once I use layers to create the structure of a page, I would like to export the
details of the layer to a css file and reference an ID in the page. However when
I try to export the layer information, it doesn't write to the css file
I'm trying to think of a way to change values in a css file using CF. How can I write
to a css file? Any thoughts?
D
~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
Hello All,
1) Can anyone recommend an application that will manage a CF Web Dev team and keep internal/external customer/clients informed as to deadline extensions and reshuffling of project priorities? Nothing to
overkill an preferabley something written in CF that we could modify. If not,
I'm running it from ...
input type=Submit value=Submit Order >
Ok Without reading that whole page. How are you running these
_javascript_s? On form submit or with a button's onclick event? If you
are running them onsubmit you are not returning false from what I
could gather
[Todays Threads]
I use Prowork Flow
http://www.proworkflow.com/
_
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 21, 2004 3:14 PM
To: CF-Talk
Subject: OT: Time tracking
Does anyone have recommendation for software that can be used for
project/time tracking. Nothing fancy, just basic
I'm sharing data from our database through remote Web Services. This one column with long product description is causing the following error.I've written an TSQL script that when in and removed all instances of amp; and replaced it with and.I run a query against the table and ask it to show me
all
So I could have them invoke our Web service and pass their order details as required arguments within our Web Service?Then take those values and insert them in our database?It's as simple as that?
On Thu, 19 Aug 2004 02:10:52 +, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
What's the
All,
What's the best way to securely transfer customer's order information from an Affiliate
back to our company, the distributor?
We are a distributor. We're using Web services to share data with our Affiliates and give
them access to our product data related tables in our database.Our
if you are using *nix, check the permissions on the folder.
_
From: Daniel Farmer [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 15, 2004 5:37 AM
To: CF-Talk
Subject: [ cffile ] trouble...
getting the following error, not sure what to make of it.
Error processing CFFILEP Error attempting
mode=777
_
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 12, 2004 8:07 PM
To: CF-Talk
Subject: OT Unix
If you want to create a directory with cfdirectory that is moving a file
from one location into the newly created directory and you wanted it to be
available for
sorry I did not know you were seeking a mode less than providing the
item for download for all users. In UNIX is should be accessible by
the same user that ColdFusion application server is running as right?
Would that provide the file to everyone the same way?
_
From: Paul Giesenhagen
Our company is moving from a one man to a three man development team.I would looking for an application that we could use preferable built in CF to help manage incoming project requests and track the progress/stage of each developer.
Does anyone have any advice or read any good articles about CF
All,
One of the columns in my database has charactors in it that the XML just does like.See error below.Is there any way I can tweek the information that's allowed through this process?Someone mentioned that the encoding in the DTD should be changed/altered.This is above me.
?xml version=1.0
\Inventory_test.cfm: line 19
17 :webservice=http://www.oursite.com/New_Product_Submission/cfcs/InventoryDataShare.cfc?wsdl
18 :method=entireinv
19 :returnvariable=aQuery
20 : /cfinvoke
21 :
Have you tried using the XMLFormat() function?
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca123
() function?
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca123.htm#wp4
5
69342
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
just
does like.See error below.Is there any way I can tweek the
information that's allowed through this process?Someone mentioned
that
y
3
f
m: line
Check your IIS Settings to make sure you
have the CFM parser setup.
IIS: Website Properties :Configuration
.cfm = D:\CFusion\BIN\ISCF.DLL
I am sure it is about the same for CF 4.5.2...
_
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 21, 2004 2:19 AM
To: CF-Talk
Does anyone have a JS script that will
determine the length of file name for a
file upload process?
This is only for the document name, not
the complete path and filename, so
document.forms[0].fileupload.value will
not work.
just trying to find a script to determine the
length of file name
much appreciated!!
_
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Monday, July 12, 2004 8:45 AM
To: CF-Talk
Subject: Re: file upload validation
Does anyone have a JS script that will
determine the length of file name for a
file upload process?
This is only for the document
I've been tasked convert a few of our Web site's basic functionality to work on a Blackberry.Search for product by part number etc.I've been to BlackBerry's Web site and it looks like I need to develop in Java. Which I'm only a beginner at.I've searched on the Macromedia site without luck.
Can I
Weuse a product called: WebLoad by Radview Software
www.radview.com
- Original Message -
From: Yves Arsenault
To: CF-Talk
Sent: Friday, June 18, 2004 7:51 PM
Subject: Load testing
Hello,
I was wondering what was the general pratice for testing your app is
Is there any way of
Hello,
I've read where _javascript_s and Layers can cause conflicts.I created a drop down menu from a hyperlink and it doesn't seem to work.I remove the layer or just the CSS link and then the menu works.It seems to have a conflict with the coordinate on the page vs the coordinates within the
the details
of the order after successful validation.
Can this be done with a Web Service?
Has any one ever done anything like this?
Will I have to know Java to do this?
http://www.macromedia.com/software/coldfusion/whitepapers/pdf/cfmx_seybold_wp.pdf
D
[Todays Threads]
[This Message
Help
I'm using a CFC to create a Web service. One of the columns in my query past
through the Web service has HTML tags in the ntext data type column.The Web
Service doesn't like it and throws an error for just this column.
I think the markup needs to be stripped from the data and then I think
What error are you getting exactly? You should have no problem returning a
string w/ HTML in it.
Error Occurred While Processing Request
Could not perform web service invocation myFunction because AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode:
At 11:48 AM 5/18/2004, you wrote:
You could encode the HTML text, but then you'll have to escape your entities.
Not sure how to do that.Can you please give me a quick example.
Thanks.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
of the language.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2
All,
We're writing CFCs tht will become Web services.These Web services are going
to be data exchanges from a few of our database tables.We want the Web Services
to be used to access our database information and import the data to their own
database.To sign up for access to these Web Services,
are
answered within minutes.
- Original Message -
From: Karl Simanonok
To: CF-Talk
Sent: Tuesday, May 11, 2004 5:57 AM
Subject: Shanje refugees
I was just notified today that Shanje.com will no longer be supporting its
ColdFusion customers after June 1.They even have a web page where
Hi,
I'm testing the ability to export data from a query using CFXML to create an XML file.
My questions are ...
1) Is the exported XML file in XHTML format?If not, what DTD is being used?
Once the query has been exported to an XML file,I want to send this XML file
to someone that's not using
I Does anyone know anything about this error.I can't figure it out.Here's my
code.
CFQUERY name=get_info datasource=#datasource# maxrows=10
Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag
from inventory
/CFQUERY
CFXML
I've tried all these suggestions and here's what the code look like now.
NEW ERROR:
Illegal character or entity reference syntax.
Illegal character or entity reference syntax.
The error occurred in D:\Inetpub\wwwroot\New_Product_Submission\cfcs\CFC_2_XML.cfm: line 23
21 :
Help,
Now I get this error.Code is listed after code.Ahh!
ERROR:
Illegal character or entity reference syntax.
Illegal character or entity reference syntax.
The error occurred in D:\Inetpub\wwwroot\New_Product_Submission\cfcs\CFC_2_XML.cfm: line 23
21 :
All,
I understand that a CF Application needs a Web server and an installation of
CF.However, has anyone every built a Cold Fusion application that resides
on a CD?Also, has anyone every built a CF app that would store data while
off line (no network connection) and then update a datasource once
You could always register one domain and have many
sub-domains from that. All depends on your hosting provider.
Example:
Single Domain:www.myFamilyName.com
Sub-Domains:
ryan.myfamilydomain.com
one.myfamilydomain.com
two.myfamilydomain.com
three.myfamilydomain.com
four.myfamilydomain.com
etc...
If the user is using the same browser window, use the
OnUnload function of JS to check if the location is not within
your domain. If so, close the session.
- Original Message -
From: NANCY SKAGER
To: CF-Talk
Sent: Saturday, January 17, 2004 1:14 PM
Subject: RE: session management help
Nevermind answered too soon. If there was a way to determine
where the user was going, you could using the OnUnload event
however not sure you can determine that.
- Original Message -
From: ColdFusion
To: CF-Talk
Sent: Saturday, January 17, 2004 1:35 PM
Subject: Re: session management
ent: Wednesday, December 31, 2003 11:50 AM
To: CF-Talk
Subject: detecting print or cancel buttons
I'm calling the print dialog box from my app and I want to detect if print
or cancel was selected, how is this done?
~~
Daniel Farmer
Coldfusion Developer / Sales / Produ
Hi Steve,
Can you please show me how to implement the first option. I really don't know anything about iframes. I would appreciate it
Thanks
CFDeveloper
You have two options here...
One, you can change the second DIV to an IFRAME and pass the variable in the
first fields value to the IFRAME
How do I pass the variable in the first fields value to the IFRAME page ?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
on the Test2.cfm. You would need to add it to a
FORM though as right now I didn't create a FORM for the text boxes but just
placed them on the page.
Steve
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 7:49 AM
To: CF-Talk
Subject
unable to do that since there is only the one strip
-- Original Message --
From: Dave Watts [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Mon, 17 Nov 2003 20:03:02 -0500
ANy other ideas before I toss the thing out the window???
You might try
Message --
From: ColdFusion Developer [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Mon, 17 Nov 2003 19:59:22 -0500
unable to do that since there is only the one strip
-- Original Message --
From: Dave Watts [EMAIL
It is after the Installation of the devices
and right after it asked for the keyboard language,
machine name, as well as the Product Key.
Reminder.. This is a LEGAL fully purchased copy
of Windows XP.
-- Original Message --
From: John Munyan [EMAIL
Hi,
I'm running a query with a specific row ID.From there, I'm trying to extract a
previous row's information where the row meets a bit value of 1.Example, (SQL
logic written out, pseudo)
queryname=pull_info
Query all entries
from xyz table
where xyz_id = value passed from form
Once this row
I'm assigning the form field values to hidden variables because it is a 4 pages form and I am passing the values from one page to another in hidden variables. I have chceked the code in both the action pages, they both have the same code, I just don't understand what's happenning here, I've turned
One thing I forgot to mention in my previous post, I have CFMX developer edition on my local development server, both the action pages display the form variables, it all works. However I've got CFMX Standard edition on my server and it does not display the form variables when the order button is
our help Guys
No, the server license won't matter.
You can save yourself a lot of work by using the preservedata
attribute of the cfform tag.Just make fields that are the same name
in the next page of the wizard.They'll be automatically populated
upon submit.
- Original Message -
Fro
Both the asp and coldfusion file that invokes the asp file are in the same directory under my webroot. In IIS I edited the .asp file properties, clicked on the File Security tab, hit the Edit button under the Annoymous access and authentication control section, checked the Annoymous access tick
yes that's correct, I am not using ColdFusion to do this, I have been asked to do this in html and _javascript_. Is it possible to do pass hidden form variables from one page to another using html and _javascript_? Are there any other ways to do this?
On Thursday 23 Oct 2003 16:24 pm, Allan
On the next page how do I get the get the value stored in the hidden variable. Can I use form.hidVariable when the method is post?
just post the form to the next pageno JS required...basic HTML
unless I'm missing your point??
- Original Message -
From: ColdFusion Programmer
Can you post few examples of storing the values in cookies? I would really appreciate your help.
You can't get them in JS with method post. Your only options AFAIK are
to use the method get or to set them as cookies before posting.
-Original Message-
From: ColdFusion Programmer [mailto
are just
having them print out a completed order form and snail-mail it or something?
Or maybe I'm missing something?
-Kevin
- Original Message -
From: ColdFusion Programmer [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 10:40 AM
Subject: Re:Hidden
I took your advise Stephen and copied the contents of the include file into a new file and saved it as a coldfusion file. I am using cfinclude to call this file. There is a if condition in the include file which is in asp.
%
if session(user.supportuser) = TRUE then
%
Do Something
%
end
Can somebody please advise me what to do?
I took your advise Stephen and copied the contents of the include file
into a new file and saved it as a coldfusion file. I am using
cfinclude to call this file. There is a if condition in the include
file which is in asp.
%
if session
a session scope with the variables you need
(like user.supportuser). Does this help?
-Mark
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 9:48 AM
To: CF-Talk
Subject: Re:CFHTTP Question!
Can somebody please advise me what to do
Makes no difference, the value in the hidden variable is still empty. I tried this is in subme function:
document.frm.txtarea1.value = document.frm.outputselection.value;
On form submission, I see the textarea briefly populated with the value in the hidden variable but it dissapears when the
actually Hugo, setting the return to false does do the trick. Sorry about that. In the function I'm returning true and it displays the value in the hidden variable in the textarea.
document.frm.txtarea1.value = document.frm.outputselection.value;
return true;
input NAME=submitbutton TYPE=submit
When I output the http response headers, this is what gets displayed
Output the Response Headers:
Date : Mon, 20 Oct 2003 15:20:34 GMT
Server : Microsoft-IIS/5.0
Content-Length : 4431
Content-Type : text/html
Explanation : Access Denied
Connection : close
Status_Code : 401
WWW-Authenticate :
so what are you suggesting? How do I use HTTP authentication mechanism?
ColdFusion Programmer wrote:
Date : Mon, 20 Oct 2003 15:20:34 GMT
Server : Microsoft-IIS/5.0
Content-Length : 4431
Content-Type : text/html
Explanation : Access Denied
Connection : close
Status_Code : 401
WWW
This is the code I have got on my Coldfusion file
CFHTTP url="" METHOD=GET RESOLVEURL=true throwonerror=yes/
cfoutput#CFHTTP.FileContent# /cfoutput
I get an error:
You are not authorized to view this page
You do not have permission to view this directory or page using the crede
der to run
menu.asp?
That is the URL you need to specify for using CFHTTP.
(Remember when using CFHTTP it is the ColdFusion server running the
request so the URL needs to be from the perspective of what the
ColdFusion server can see the menu.asp page as which could mean using a
127.0.0.1 or localho
I was hoping somebody could show me how to do this. Thanks
If the files are big this will eat memory .
Consider using the underlying OS to dfo this sort of thing.
use cfexecute to run a batch file for instance, e.g.
COPY SupportiSearches*.log destinationfile.log
That should do exactly what
output.
cfexecute name=mybatchfile.bat /
Should do the trick.
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: 15 October 2003 10:34
To: CF-Talk
Subject: Re:CFFILE Question
I was hoping somebody could show me how to do this. Thanks
If the files are big
.
Craig.
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: 15 October 2003 10:49
To: CF-Talk
Subject: Re:CFFILE Question
I've tried doing this and I get an error:
cfexecute name=copy
D:\CFusionMX\wwwroot\logReport\SupportiSearches*.log destination.log
timeout=5
wolla! got it to work finally, thanks Craig.
Error number 2 = Can't find file. Try using the full path of the batch
file.
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: 15 October 2003 11:05
To: CF-Talk
Subject: Re:CFFILE Question
Craig, I don't
?
wolla! got it to work finally, thanks Craig.
Error number 2 = Can't find file. Try using the full path of the batch
file.
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: 15 October 2003 11:05
To: CF-Talk
Subject: Re:CFFILE Question
Craig, I do
This shows the batch files cmd output but does not error:
cfexecute name=D:\CFusionMX\wwwroot\supportSearches.bat timeout=5/
Is there a way to not display the output?
Yes, if you're reading the resultant file straight away, you have to
make sure the batch file has finished 1st. (This is
Nice one, should have thought about that, many thanks Craig
cfsilent ??
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: 15 October 2003 12:48
To: CF-Talk
Subject: Re:CFFILE Question
This shows the batch files cmd output but does not error
web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 11:59 AM
To: CF-Talk
Subject: Re:SQL Statement help!
I've tried this and it errors:
cfoutput
, listGetAt(fileLine,3));
QuerySetCell(qTmp,Status, listGetAt(fileLine,4));
/cfscript
/cfif
/cfif
/cfloop
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: 09 October 2003 10:43
To: CF-Talk
Subject: Re:Looping through a list, setting each listItem
Hi Jochem, Can you explain what the where statement in your code does, I don't understand the the EXTRACT(DAYS FROM CURRENT_TIMESTAMP - DateTime) 7 bit
Many Thanks
Allan Clarke wrote:
I have this table that keps a log
of the user search activity. For ex, on the site
search page of the site,
, SearchString
/cfquery
I get this error:
Query Of Queries syntax error.
Encountered WHERE at line 0, column 0.
ColdFusion Programmer wrote:
Hi Jochem, Can you explain what the where statement in your code
does, I don't understand the the EXTRACT(DAYS FROM
CURRENT_TIMESTAMP - DateTime) 7 bit
Read
at line 0, column 0.
ColdFusion Programmer wrote:
Hi Jochem, Can you explain what the where statement in your code
does, I don't understand the the EXTRACT(DAYS FROM
CURRENT_TIMESTAMP - DateTime) 7 bit
Read it inside out:
CURRENT_TIMESTAMP - the current date and time, 'now'
DateTime- your
ideas?
ColdFusion Programmer wrote:
This is what I'm doing, and I get an error. I'm using SQL Server
2000
No, you are not. Since your dbtype is query, you are using CF.
cfquery name=lQuery2 dbtype=query
SELECT UserName, SearchString, Count(SearchString) AS Occurences
FROM
WHERE (#DateFormat
I now get a different error
Query Of Queries runtime error.
Unsupported type comparison.
ColdFusion Programmer wrote:
Guys, I'm sorry for so many errors on my part. Jochem, the code your
posted throws an error,
Error Executing Database Query.
Query Of Queries syntax error.
Encountered
I think this is what you mean
DateTime - 2003/09/01 11:52:16
Now - {ts '2003-10-10 15:28:19'}
whats the value of dateTime parse out to?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion
')# DateTime
GROUP BY UserName, SearchString
/cfquery
ok so format that value, with dateFormat, enclose it in 's and you should be
good.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion
of creating the query and takes the as a
qualifier into consideration. Replace your script by mine and it
should work.
-Oorspronkelijk bericht-
Van: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Verzonden: wo 8/10/2003 17:32
Aan: CF-Talk
CC:
Onderwerp: Re:Looping through a list
,1,matchStruct.len[1]);
j = j + 1;
}
else exit = true;
}
}
}
/cfscript
h1Log/h1
pre
#fOutput#
/pre
cfdump var=#qTmp#
/cfoutput
Pascal Peters
Certified ColdFusion MX Advanced Developer
Macromedia Certified Instructor
LR Technologies
Av. E. De Mot, 19
1000 BRUSSELS, BELGIUM
Tel: +32 2 639 68 70
The log file stores a log of what the user has been searching on the site search. For example if the user searches for the keyword Fusion, the log file stores the information like this:
I want to display the top 5 or 10 search keywords that users regularly search for and because this is logged
#lKeywordFreq.SearchString#
/TD
TD vAlign=bottom width=50%
#lKeywordFreq.Freq#
/TD
/TR
/cfoutput
Try:
select top 10 count(distinct SearchString) AS total, SearchString
FROM clients
GROUP BY SearchString
order by total desc
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED
601 - 700 of 837 matches
Mail list logo