I find Commerce Server to be a very robust solution.
If I were you I'd take the opportunity to use/learn it.
You'd be hard pressed to provide similar functionality with ColdFusion only,
especially since
it does include features tightly integrated with MS SQL Server 7/2k such as:
- log
Try to reverse the problem: run the query in MS SQL and select from Oracle.
Create a linked server in MS SQL to point to the Oracle DB.( See MSSQL BOL
for details on how to do this)
You must install the Oracle client( Net8 or SQL*Net ) on the SQL Server
machine for this to work.
Then run a query
Yes, it is possible. In SQL Server you would do something like this:
SELECT ColumnName
FROM tableName
WHERE CAST(ColumnName AS varbinary)= CAST('Test Query' AS varbinary)
OR
SELECT ColumnName
FROM tableName
WHERE CONVERT(varbinary,ColumnName)= CAST(varbinary,'Test Query')
In SQL Server 7
Regular selects should work just fine.
I also have the 'Enable retrieval of long text' checked in CF administrator.
HTH
P.
-Original Message-
From: Tim Dempsey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 11:02 PM
To: CF-Talk
Subject: Question about retrieving Oracle
ThinWeb also offers a free Type 4 JDBC 2.0 driver for SQL Server called
TWFreeTds.
It improves on FreeTDS and it works great.
www.thinweb.com
P.
-Original Message-
From: Richard Kuryk [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 12:01 PM
To: CF-Talk
Subject: RE: OT - JDBC
Look up CFX_ImageResize in the tag gallery.
HTH
P.
-Original Message-
From: admin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 10:20 PM
To: CF-Talk
Subject: Re: Thumbnails
Thanks Mark, and others !
What I wanted to do was genererate the thumbnails at view time. That is
If you have CF 5.0 RC 1 look under CFUSION\cfx\java to see the details of
the java CFX implementation.
P.
-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 23, 2001 2:18 AM
To: CF-Talk
Subject: Re: CFX and the caller scope?
I wish I had more
Yes it does.
It worked for me on CF 4.5 Solaris and CF 4.52 Win2k using native
drivers
and with the 'Enable retrieval of long text' checked in the CF admin.
Selects work by default, here's the syntax for inserts and updates.
CFQUERY NAME=name DATASOURCE=#DSN#
INSERT INTO CLOB_TABLE(
Yes, but you'll have to build the SQL statement dynamically as a string and
execute it via EXEC(@SQLString) or sp_executesql..
See BOL for details.
P.
-Original Message-
From: Dale Fontenot [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 07, 2001 1:03 PM
To: CF-Talk
Subject:
Take a look at CFX_DynamicImage in the tag gallery. It does everything you
want and more.
I believe it's commercial though.
HTH
P.
-Original Message-
From: John McKown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 11:21 PM
To: CF-Talk
Subject: Will MM Create Server-Side Image
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
ANDTABLE_NAME = '#SOME_TABLE_NAME#'
HTH
P.
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 6:47 PM
To: CF-Talk
Subject: SQL 7.0 (checking for the
I wrote a custom tag that does this:
CF_RANDOMSTRING
LENGTH= 12
CHARSTART = 1
CHAREND = z
OUTPUTVARIABLE=myString
generates a pseudo random string of specified length containing only
characters
found between the ascii values of CHARSTART and CHAREND
CFPARAM
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'events0301'
HTH,
P.
-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:07 AM
To: CF-Talk
Subject: existence of table
Is there a way to check for the existence of a database
Try,
CFQUERY NAME="q" DATASOURCE="#DSN#"
SELECT *, SUBSTRING(lname,1,1) AS FirstLetter
FROM MyTable
ORDER BY FirstLetter
/CFQUERY
CFOUTPUT QUERY="q" GROUP="FirstLetter"
#FirstLetter#
CFOUTPUT
#lname#, #fname#
/CFOUTPUT
/CFOUTPUT
CFOBJECTCACHE ACTION="CLEAR"
will clear all the cached queries on the server.
Undocumented and unsupported
P.
-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 4:20 PM
To: CF-Talk
Subject: Can you clear cached queries?
After looking through
How about a 'zipping' utility? Have them zip the images up into one file and
upload it.
Then, you can unzip them on the server.
P.
-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 11:35 AM
To: CF-Talk
Subject: Batch Image Upload
I was
I get the same results on my 4.01 server. CFSCRIPT is faster. (?)
http://209.44.100.254/looptest.cfm
P.
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 9:23 PM
To: CF-Talk
Subject: Re: (code) Looping is faster in 4.5.2
My running
Use sp_executesql instead of EXEC() to run your dynamic SQL. It caches the
query plans.
P.
-Original Message-
From: Eric Barr [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 7:59 AM
To: CF-Talk
Subject: RE: OT STORED PROCEDURES
I've gotten one result set back from exec
What DBMS?
-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 2:03 PM
To: CF-Talk
Subject: Faster Join
What would be faster an inner join, an outer join, or a where
something = something join. I am working with huge queries and a
Try the CF_FusionADO custom tag in the Tag Gallery.
P.
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 7:49 AM
To: CF-Talk
Subject: OT: SQL read of column attributes in a table
Good Morning,
I it possible through SQL to read the
I guess that would be CGI.HTTP_ACCEPT_ENCODING.
P.
-Original Message-
From: Peter Stolz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 10:30 PM
To: [EMAIL PROTECTED]
Subject: RE: [Compress HTML output]
This is great!
One question though:
The servlet version checks
Yes, it is possible. Create a linked server from SQL 7 to Oracle(using
SQL*NET)
Then you can write queries like:
CFQUERY NAME="join" DATASOURCE"SQL7"
SELECT *
FROM SQL7Table AS A INNER JOIN OraLinkedServer.Catalog.Schema.OraTable AS B
WHERE .
/CFQUERY
P.
Can we see the SQL code?
P.
-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 07, 2000 1:58 AM
To: CF-Talk
Subject: Another SP problem...
Error Diagnostic Information
ODBC Error Code = 07001 (Wrong number of parameters)
The digits to the right of the decimal point were truncated because
SQL Server stores decimal numbers with precision(max total number of digits)
and scale(max digits to the right of the decimal point).
The default scale is 0, that is no digits to the right of the decimal point.
You can change
This is certainly possible using CFOBJECT and VBA.
Do a search for 'Working with Tables' in Word's VB editor help to see code
samples.
ASP is probably a better choice than CF for this one.
P.
-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 30,
Another idea:
For Word:
Run the queries, create an HTML file and save it to disk.
Then open it in Word and save it as a Word doc.(CFOBJ..)
It should look decent if the formatting isn't too complicated.
For Excel:
Save the file as HTML.
Do a web query programmatically ( CFOBJ..)
This makes an
In SQL Server you can do something like this:
-- creates empty table / must be fast since it locks sys tables
SELECT itemnum, IDENTITY(int) AS rownumber
INTO #TempItems
FROM items
WHERE 1 = 2
INSERT #TempItems
SELECT itemnum
FROM items
WHERE user_id = 12345
Then to get
Use CF_BLOCK from the Tag Gallery.
This is the tag's description as written by the author:
"This tag simply stops the execution of the current template for the
specified number of seconds. No loops or temporary files. Does not consume
ANY server resources.
It uses only two nested CFLOCKs that
For Access try SUM instead of COUNT
cfquery name="countyesnos" datasource="#dsn#"
SELECT SUM(IIF(success = 1, 1, 0)) AS successyes,
SUM(IIF(success = 0, 1, 0)) AS successno
FROM survey
/cfquery
P.
-Original Message-
From: Jaime Garza [mailto:[EMAIL
CF_BLOCK
P.
-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 11:36 AM
To: CF-Talk
Subject: RE: Delay
correct. I don't preach server side timers, I just replied to somebody's
question. They need a timer, written in CF and running
Try:
CREATE PROCEDURE GetContacts @alpha varchar(1) AS
SELECT Contacts_Main.company
FROM Contacts_Main
WHERE (Contacts_Main.company LIKE @alpha + '%')
ORDER BY Contacts_Main.company
P
-Original Message-
From: Top-Link Tech (John Ceci) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
Check out:
http://www.inquiry.com/techtips/asp_pro/10min/10min0800/10min0800-1.asp
It's done in ASP but you can use CFOBJECT to do the same.
P.
-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 2:56 PM
To: CF-Talk
Subject: Excel Charts
I
Have you tried using native drivers intead of OLE DB?
P.
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 4:39 PM
To: CF-Talk
Subject: Extra attributes for OLEDB conn. strg in Oracle
Is it possible to add additional attributes for the
Check out :
http://www.vue.com/allaire/
P.
-Original Message-
From: Venkata Ramakrishna [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 23, 2000 1:40 AM
To: CF-Talk
Subject: CFExam at India
Hi,
Iam from India and want to know where can i take the
Allaire certification exam in CF
There is a complete tutorial on setting up OLE DB datasources in the CFDJ
archive:
http://www.sys-con.com/coldfusion/archives/0207/smith/index.html
P.
-Original Message-
From: Reuben King [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 22, 2000 8:50 PM
To: CF-Talk
Subject: Question
Try this:
FORM ACTION="my_action.cfm" METHOD="POST" NAME="myform"
INPUT TYPE="TEXT" NAME="TEST"
/FORM
A HREF="javascript:document.myform.submit();"Submit/A
P.
-Original Message-
From: David B Brooks [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 22, 2000 5:38 PM
To: CF-Talk
You can do this using java CFXs.
Allaire has an example that does just what you want in their CFX_J 1.0
download.
P.
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 21, 2000 4:06 PM
To: CF-Talk
Subject: ImageManipulation with Cold Fusion
37 matches
Mail list logo