Matt,
Do the pages truly have to be static? I do something that only requires
CFFILE to generate its run of templates ... which are just copies with
different filenames, where the filename incorporates the key ID and there's
code inside to pull that ID out and use it. Doesn't affect the
Anyone?
Why do you think I can't get the Rowcount AS Deleted in cfoutput?
DELETE from Orders WHERE
Product_id=#val(Product_id)#
SELECT ROWCOUNT AS Deleted
error cfoutput#QuerynameDeleted#/cfoutput
__
Get Your Own
Maybe cfexecute or xp_cmdshell and the dos 'date' command?
Ian
-Original Message-
From: Gregory Harris [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2002 05:53
To: CF-Talk
Subject: RE: Change Server Time, is this possible ???
Well if you know a little C++ you could probably do a CFX tag
SET NOCOUNT ON
DELETE from Orders WHERE
Product_id=#val(Product_id)#
SELECT Deleted = ROWCOUNT
SET NOCOUNT OFF
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant
Hi,
I want to insert an uploaded file directly into a SQL database field So
after the user has uploaded the file to our CF server, at some point later
(probably overnight), we can move this file to store it directly in the db
I have no idea how to make a start on this (the file's already
I want to insert an uploaded file directly into a SQL database field So
after the user has uploaded the file to our CF server, at some point later
(probably overnight), we can move this file to store it directly in the
db
I have no idea how to make a start on this (the file's already
That did it! Thanks Paul.
- Original Message -
From: Paul Hastings [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 12:34 PM
Subject: Re: count delete [anyone?]
SET NOCOUNT ON
DELETE from Orders WHERE
Product_id=#val(Product_id)#
SELECT Deleted =
Yes, we want to be able to use the SQL server indexing. In the db I'm
already storing a reference to the file, for when someone needs to download
it.
We're finding that Verity is way too slow when we have a mixture of several
Verity database collections and a Verity file collection. When we
Why would Excel ODBC data sources that have been working for several months
all of a sudden all break?
We have a CF application that uses about a dozen different Excel
spreadsheets for data sources Depending on the type of report requested, we
query one of the Excel spreadsheets using ODBC to
Anyone know if there's such a thing as an MS SQL Server
7.0 evaluation version/developer's edition? I grabbed the
SQL 2000 trial in anticipation of doing some work for a
client, now it turns out they're running 7, and I'd like to
do this bit of development on the same version...
- Gyrus
I have a template that I want to display Please wait text, then
go
through a CFIndex Process, with a complete message when done.
This
is displayed in a pop-up window. I find that when the CF process
starts, the window goes blank until the process is done, then
displays all the text.
I know some of us CFers still must code in other languages, and I found
this little jewel for editing the PHPini
http://wwwanalogxcom/contents/download/network/phpconfhtm
Success is a journey, not a destination!!
Doug Brown
Hi,
I know ColdFusion 5 comes with the 36 Merant ODBC drivers, if I install the
40 set of drivers will it be supported by ColdFusion?
TIA,
Deb
_
Join the worlds largest e-mail service with MSN Hotmail
http://wwwhotmailcom
Running CF 50 and when we run our search against the collection, it returns
what from the surface appear to be inconsistent results
I will search on hybrid and first 7 articles will be foreign text and
when I search the body that word does not appear
Next article will be in English and does
Can the column widths be resized dynamically to their widest value?
What I
found was that, without any VBScript or COM automation, this was not
possible.
I would be interested in seeing an example of doing this another way,
if
anyone has one.
Mike
-Original Message-
From: list peters
Anyone know if there's such a thing as an MS SQL Server
70 evaluation version/developer's edition? I grabbed the
SQL 2000 trial in anticipation of doing some work for a
client, now it turns out they're running 7, and I'd like to
do this bit of development on the same version
There is a
Yes, but it requires Excel 2000perhaps I can persuade them to upgrade.
Meanwhile I was hoping CFOBJECT would do the trick.
- Original Message -
From: list peters [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 8:16 AM
Subject: Re: CFOBJECT
With SQL Server 2000 out, I doubt you can still get SQL Server 7
evaluation.
But you will have no trouble accessing a SQL Server 7 server w/ SQL
Server 2000 utilities.
At 03:01 PM 03/01/2002 +, you wrote:
Anyone know if there's such a thing as an MS SQL Server
7.0 evaluation
There wouldn't happen to be one of those to edit apache? That's the only
thing that stops me from using it. Don't have the time to really sit there
and do it. One of these days I will.
Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire
-Original Message-
From: Douglas
On Fri, 1 Mar 2002 10:23:57 -0500, phil e hebenstreit wrote:
Running CF 5.0 and when we run our search against the
collection, it
returns
what from the surface appear to be inconsistent results.
I will search on hybrid and first 7 articles will be foreign
text and
when I search the body that
Hi Mark,
I've determined this now. Its returning the correct results, because some
of the articles are uploaded files (html) that were created in Word and
contain a bunch of excess html code at the type (one being style sheets that
contains the word hybrid, which what the search word was). So
look into the verity spider
-Original Message-
From: phil e hebenstreit [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 11:14 AM
To: CF-Talk
Subject: RE: Verity Issue - Returning Incorrect Results?
Hi Mark,
I've determined this now. Its returning the correct results, because
Jason said,
Is there a better way, other then converting
all content to static pages? (I don't want to
use query caching as it will not do and eat
all the memory)
The method I referred to isn't going to do anything for you if you are
looking to reduce load on your db server and CF itself
At the risk of sounding lame, is there any documentation on the Verity
search engine that comes with CF?
My applications are full of includes, modules, etc. and I chose NOT to
use
verity because it would always return only a partial page.
Can I use it as a spider, I mean, follow links on the
You can still pick up copies of SQL Server 7, and it is a little
cheaper
than before they released SQL 2000.
http://cnet.search.com/search?timeout=3tag=ex.cn.1.srch.cnetq=sq
l+server+7
Mike
-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 10:02 AM
On Fri, 1 Mar 2002 11:18:32 -0500, Sean McCarthy wrote:
look into the verity spider
-Original Message-
From: phil e hebenstreit [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 11:14 AM
To: CF-Talk
Subject: RE: Verity Issue - Returning Incorrect Results?
Hi Mark,
I've
Tim,
In you application.cfm page set a variable to the base reference and then
use it in you pages.
Example:
cfset baseRef=http://rootdomain.com/
Then when calling the graphics in your header and footer includes:
img src=#baseref#/content/graphics/image.jpg
Best regards,
Dennis Powers
UXB
Tim,
Use aboslute instead of relative paths
ie
/dept/content/graphics/imagenamejpg
This will fix the problem because the first backslash in front of dept tells it to
drop to the root
On Fri, 01 March 2002, Tim VanderPloeg wrote:
I must be missing something very simple but I am new to
Tim;
Um... okay, I think I know what the problem is.
The header and footer files are in a different directory than the
content
files. The client Web browser will be looking for the files based on
the
physical location of the content files on the Web server, not based on
the
location of the
Yes, we want to be able to use the SQL server indexing
In the db I'm already storing a reference to the file,
for when someone needs to download it
We're finding that Verity is way too slow when we have a
mixture of several Verity database collections and a Verity
file collection When
Anyone ever seen this?
CF5/Win2k/Apache/Oracle 8.0.5 (using ODBC driver)
This is from a basic update statement. I have plenty of others and they
don't have this problem...
Error,1400,03/01/02,11:07:21,,Data Access ErrorP Unknown Data
Access Error.P
Error,1400,03/01/02,11:07:21,,65.208.124.109,
Mike,
If you have access to the CF docs, which are linked from the cfadmin
check out
cfdocs/Advanced_ColdFusion_Administration/VerityPart.html
I read through it a week or two ago and it has a good coverage of the
functionality provided by Verity with CF and how to use it and tweak it,
Hello everyone,
As its sitting on a month and half of looking for a job and no luck
yet I was wondering if anyone has any leads for the
Minnesota,Minneapolis area I could check out and hopefully get hired
Thank You
Troy Montour
Vampires Inc
4663 Main ST
Fridley, MN 55421
Phone: (612)
Troy, it looks like a definite nightmare out there right now for jobs. I
find nobody wanting to hire , but several wanting just contract work.
you figure California would be busting out the seams with jobs,
but.NOT
Success is a journey, not a destination!!
Doug Brown
- Original
Hi All,
I'm trying to get the Flash Connector Kit examples to run and I'm having some problems.
I've changed the path from localhost to the domain I'm hosting in the Flash
ActionScripts of the
examples and that works fine. I can browse to the greeting exampletype in my
name...hit try
Do a search on the houseoffusion.com mail list there are a number of
examples. The docs would reference it as the vspider.
Heres Jeffs examples:
http://www.spectrumastro.com/veritydemo/index.cfm
Ahh found it another good example:
Hi,
If I want to query a table for an id and then save that id to another
table, can I do it in the same SQL statement? If so, how do I refer to
the value from the first select? It's something like this:
cfquery datasource=#datasource#
cfloop from=1 to=whatever index=index
select id from
You might be able to do something like so, never tried it.
declare @this_id int
begin
select @this_id = (id)
from your table
end
insert into table2 (tablerow)
values (@this_id)
Success is a journey, not a destination!!
Doug Brown
- Original Message -
From: Douglas Jordon
Matthew,
Yes, a lot of code is being generated (as Jochem pointed out, 2MB).
What code is run before
CFIF CheckCache.RecordCount
cflocation url=/cache/#checkcache.file#
Jochem,
The only code being written prior to that is a query called checkcache.
However, CFHTTP is run on the first
Those documents are pretty cool. I had no idea there was an actual
spider! I
don't need to use it now, but most of the sites I build are in Fusebox
and I
would want to spider those sites instead of index them.
The spider collection is limited to links on the localhost. Has anyone
worked with
Hi all,
I don't know Oracle very well, and a client is getting this error from a
website I built for them that uses Oracle
Oracle Error Code = 1653
ORA-01653: unable to extend table Timentrytabledetails by 41 in
tablespace TIMENTRY
This is happening whenever someone tries to add a new record
check the disk space on the drive on which the table resides. you may
be out.
christopher olive, cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday,
in SQL Server:
INSERT INTO table_2
(table_1_id)
SELECT id from Table_1
christopher olive, cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
Sent: Friday, March
Hello,
I know this has been asked 1000's of times, but I lost the code: Anyone
have a simple Page Up/Page Down CF code I want to insert it into a
display page to have it display fivce records at a time
Many thanks for all the help!
You can download our QDNext for free:
http://www.quilldesign.com
It allows for next/previous and page series's as well ..
It's also free!
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
- Original Message -
From: Robert Orlini [EMAIL PROTECTED]
I called verity, 10K for the full... but as they said: In the current state
of the market that price is... negotiable
You can spider multiple sites on the same box though
Sean
-Original Message-
From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 2:06 PM
That version of the spider is limited to 10 sites, but they can be ANY site.
Additional site packs cost extra. Did they quote you for the Silver
version of the K2 Enterprise system? If so definitely check into the Gold,
shouldn't be too much more than the silver and you get a lot more (the
This usually happens when you have an infinite loop in the Flash Player.
Check you ActionScript to verify that you are not hanging up while
trying to connect to the server.
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 10:06 AM
To:
I'm just trying to get the examples that come with the connector kit working. Please
tell me that
Macromedia didn't ship broken examples.
I'm brand spankin new to this, so if you have something a tad more detailed to look
for in the
ActionScript I'd be very grateful.
From what I've found so
it also happens when you simply pass too much data to a FLASH control.
~Simon
Simon Horwith
Macromedia Certified Instructor
Certified Advanced ColdFusion 5 Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-Original
What's the problem with referencing the stylesheet in the application.cfm
file? I have done this on several websites and never seen a problem before.
Here's the code I use:
LINK REL=STYLESHEET TYPE=text/css HREF=stylesheet.css
Is there an issue with doing it this way?
Thanks,
Mike
At
Thank you. Works fine.
Robert O.
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 3:01 PM
To: CF-Talk
Subject: Re: page up/down
You can download our QDNext for free:
http://www.quilldesign.com
It allows for next/previous and page
What's the problem with referencing the stylesheet in the
applicationcfm file? I have done this on several websites
and never seen a problem before
Here's the code I use:
LINK REL=STYLESHEET TYPE=text/css HREF=stylesheetcss
Is there an issue with doing it this way?
Not really,
Yes, that worked. Thank you.
Douglas Brown wrote:
You might be able to do something like so, never tried it.
declare @this_id int
begin
select @this_id = (id)
from your table
end
insert into table2 (tablerow)
values (@this_id)
Success is a journey, not a destination!!
Glad it worked for you ...
We haven't updated QD Next in awhile .. it could probably use a few tweaks
..
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
- Original Message -
From: Robert Orlini [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
So wouldn't it be simple then to assign a var from the application.cfm
file to the HREF= name?
I.e.,
LINK REL=STYLESHEET TYPE=text/css
HREF=cfoutput#varfromapplicationfile#/cfoutput
| -Original Message-
| From: Dave Watts [mailto:[EMAIL PROTECTED]]
| Sent: Friday, March 01, 2002
I've written a custom tag that does that, and is fairly customizable. I
just wrote it for in house use so it isn't anything special, but you are
more than welcome to the code and you can change it however you'd like.
Contact me off list if you'd like me to send it to you.
Jared
[EMAIL
Hello all I am trying to write a simple search engine, and would like
to replace certain commonly used prepositions from the search string
such as 'a','the','for', etc
I have an array of the prepositions that I would like to remove, however
the problem I have is that it is removing them when
Can someone help me make this work?
I'm not sure how to explain it clearly, so I'm hoping the code/comments make
sense
!--- assign show variable ---
CFSET show = userID
!--- assign sub value to value set above ---
CFSET evaluate('#show#')= allUsers
!--- debugging output ---
CFOUTPUT
first
To set a dynamic variable, use setVariable:
cfset show = userID
cfset setVariable(show,allUsers)
You will still need evaluate to display it though.
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
If you are trying to dynamically assign a style sheet for each page, you
could do the following:
html
head
titleTitle/title
link rel=stylesheet href=includes/css/styles.cfm type=text/css
/head
body
..
/body
/html
Them, in your styles.cfm page, you could have:
cfsetting enablecfoutputonly=yes
Actually, there is a shorthand for this:
change:
cfset Evaluate('#show#') = allUsers
to:
cfset #show# = allUsers
- Original Message -
From: Raymond Camden [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 2:36 PM
Subject: RE: assigning a value to a dynamic
Ahh- Very good! Thank you!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Raymond
Camden
Sent: Friday, March 01, 2002 4:37 PM
To: CF-Talk
Subject: RE: assigning a value to a dynamic variable?
To set a dynamic variable, use setVariable:
If you are trying to dynamically assign a style sheet for
each page, you could do the following:
html
head
titleTitle/title
link rel=stylesheet href=includes/css/stylescfm
type=text/css
/head
body
/body
/html
Them, in your stylescfm page, you could have:
cfsetting
| What's the problem with referencing the stylesheet in the
| applicationcfm file? I have done this on several websites
| and never seen a problem before
|
| Here's the code I use:
|
| LINK REL=STYLESHEET TYPE=text/css HREF=stylesheetcss
|
| Is there an issue with doing it
Okay, that works too- and it's a little shorter... I like it-
Thanks!
Actually, there is a shorthand for this:
change:
cfset Evaluate('#show#') = allUsers
to:
cfset #show# = allUsers
- Original Message -
From: Raymond Camden [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Going from limited memory of the subject here, but try something like this:
[\w the|a|..] (the 'the|a|..' part would be your preposition
list...)
I think the \w means you are looking for whole words. Or it might be \W...
Hope that helps some...
Shawn Grover
-Original
Hi All
I know that you can see the datasource names and the
servers they are pointing to in cfadmin But, is there
another way to find the list of datasources and the
servers they point to?
Also, even in cfadmin, we can just see the datasource
name, but until we don't click on the the datsource
Hi All
I know that you can see the datasource names and the
servers they are pointing to in cfadmin But, is there
another way to find the list of datasources and the
servers they point to?
Also, even in cfadmin, we can just see the datasource
name, but until we don't click on the the datsource
The servers registry holds all of the datasource information for the
CFAdmin, you can see it in there .. but it doesn't give the server
information...
Software/allaire/datasources
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
- Original Message
Control PanelODBC Settings
Regards,
Howie
- Original Message -
From: bajaria aslam [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 4:55 PM
Subject: Any other way to look at datasources?
Hi All.
I know that you can see the datasource names and the
Or..
SetVariable(Show,'alUsers');
change:
cfset Evaluate('#show#') = allUsers
to:
cfset #show# = allUsers
- Original Message -
From: Raymond Camden [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 2:36 PM
Subject: RE: assigning a value
CF_Datasource will give you a list of datasources on the server...
http://www.cfdev.com/products free encrypted version.
+
Pete Freitag ([EMAIL PROTECTED])
CTO, CFDEV.COM
ColdFusion Developer Resources
http://www.cfdev.com/
-Original Message-
Yeah... I think it's called notepad
:-)
-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 7:50 AM
To: CF-Talk
Subject: RE: PHPConfig
There wouldn't happen to be one of those to edit apache? That's the only
thing that stops me from using
Very easy... The easiest thing to do is parse the logs, but that's a pain.
In cf server, you can set a global error handling template. Here's the code
because it's Friday and I feel like giving back:
YAY! Free Code!
link rel=stylesheet type=text/css href=/styles/worp.css
cfparam
I think you also need a cfcontent type=text/css tag in ther, but I'm not
sure...
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 1:52 PM
To: CF-Talk
Subject: RE: Attaching CSS style sheet
If you are trying to dynamically assign a style
If you feel like being risky and using undocumented functions theres:
CFUSION_GETODBCDSN()
see macromedia's article on the undocumented functions / tags
http://www.macromedia.com/v1/handlers/index.cfm?ID=11714Method=Full
-Original Message-
From: Pete Freitag [mailto:[EMAIL
err...you might want to dereference the session collection first and
lock
this call, otherwise you get instability issues. kinda like this:
cflock scope=session type=readonly timeout=5
throwontimeout=yes
cfscript
mySession = structnew();
mySession =
wddx is just another form of an xml document. you can reference the dtd for
wddx here: http://www.wddx.org
i am not sure of your question though, they are two different sets of
technologies that have XML in common.
cheers,
Timothy Stadinski
Senior Software Engineer
Afternic.com
[EMAIL
Or you could use ListReplace with as the delimiter -- as long as you
force everything lower case first.
- Original Message -
From: Jared Stark [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, March 02, 2002 10:10 AM
Subject: Regular Expression Help
Hello all. I am
Well, if you access to use CFREGISTRY, you can look at the datasources
entered through the ColdFusion Administrator:
CFREGISTRY ACTION=GetAll
BRANCH=HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\
Datasources
TYPE=Key
NAME=dsnQuery
Then just output the dsnQuery
I have a funny feeling Rey knows all about wddx already ;-)
It's openwddx.org now though.
jon
- Original Message -
From: Tim Stadinski [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 6:46 PM
Subject: RE: XML question
wddx is just another form of an xml
Do you envision being it a $600 plug-in for VS .Net?
-Original Message-
From: Gregory Harris [mailto:[EMAIL PROTECTED]]
Just as a thought to throw out there, with so many other languages
porting over to .net, anyone see a ColdFusion.net in the future?
Granted it's not an open
Does anyone know of a online source with some examples of accessing WDDX
packets from within a VB application? I know Forta's book has one example
of this and the SDK for WDDX has a little bit, but that is about all I have
been able to find. Like how it is www.openwddx.org now but the SDK points
I have a book called SQL The Complete Reference that came with a CD that has
an evaluation version of SQL Server 7, as well as versions of Oracle,
Informix, Sybase and DB2
Osborne ISBN 0-07-211845-8
HTH
Mike
_
Send and receive
85 matches
Mail list logo