CFQUERYPARAM and MSSQL7 TEXT fields
We're using CFQUERYPARAM tags on a project for the first time (CF5 Windows
/ SQL Server 7) and we've had a lot of success in improving the general
performance of the application.
We just ran into one stumbling block: TEXT fields. If we use the
CFQUERYPARAM SQLDATATYPE of "CF_SQL_VARCHAR," our queries will run until we
go larger than the 8000 character limit of a SQL 7 Varchar, and then it
will throw an error ("Right truncation of character data"). We need to
store more than this amount of character data, hence the choice to use TEXT
fields in the first place.
According to MSDN, the ODBC binding type of LONGVARCHAR corresponds to the
TEXT field type, but using "CF_SQL_LONGVARCHAR" exhibits the same behavior.
Anyone know how to fix this?
Brian
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Setting a VARIANT_BOOL COM attribute from CF
I'm trying to use a VC++ COM object that has some VARIANT_BOOL attributes from ColdFusion via CFOBJECT. No matter what value I set the attribute to (1, 1.0, -1, -1.0, 0, true), it's always FALSE. Double/Int/Float parameters and methods work just fine. Is this a variable typing/casting issue? Anyone have any ideas what to try? Brian ___ Brian Panulla [EMAIL PROTECTED] "Do you ever get down on your knees and thank God you have access to my dementia?" - G. Costanza __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Flash 5 Player for IE
Last I looked you needed to become a "partner" of sorts of Macromedia to download the installer (for inclusion on CD-ROMs, or use on an Intranet, etc). All this required was filling out a license agreement which included a requirement that you not distribute the package except as permitted. Check out this link (may be wrapped): http://www.macromedia.com/support/shockwave/info/licensing/faq.html Good luck! Brian At 06:29 AM 05/16/2001 -0400, you wrote: >Date: Tue, 15 May 2001 19:28:54 -0700 >From: David Shadovitz <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: OT: Flash 5 Player for IE >Message-ID: <[EMAIL PROTECTED]> > >I work on a secure intranet, with no access to the internet. In order to use >Harpoon (MMFCKCF just doesn't sound nice) I need the Flash 5 Player. The >problem is that when you're using IE, Macromedia doesn't offer the chance >to download an installer like it does when you're using Netscape. It >installs it directly into the IE browser. > >Any advice? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-Talk-list V1 #258
Is there a MIME type associated with .js files? You may need to throw a CFCONTENT tag at the beginning of your CFM file to tell the browser that it is definitely a JS file rather than a text or HTML file (which is default for CFM files I believe). The browser shouldn't care about the extension of the filename... only the MIME type offered at the beginning of the file by your Web server. The PC I'm using here doesn't seem to have a mapping for .js, so I can't tell if it uses a separate MIME type or not. Brian At 07:31 AM 04/07/2001 -0400, you wrote: >Date: Fri, 06 Apr 2001 23:27:55 -0400 >From: "Steve Reich" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: CF Server parsing .js files... >Message-ID: <[EMAIL PROTECTED]> > > > That's the way we do it... works like a champ. When your stylesheets get > > big, you really should link to them, rather than include them, so that > > browsers can cache them and speed up all your pages. Works for us in > > Netscape, too, vs. Steve's experience in the next post. > > >It's not a stylesheet. It's a javascript source file that I'm trying to >include with CF variables > >This works fine in IE and NS... > > > >This works in IE but not in NS... > > > >I'm thinking I need to find another approach to what I'm trying to do. >Netscape seems to need the .js extension to reference as a valid source >file. > >Steve Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SQL Replication
Jim, Do both sites run ColdFusion? One possibility that I've been kicking around is using CF's WDDX to exchange data between servers via CFHTTP calls I think this model would work: 1) "Extranet" server receives new listing from local LAN users. 2) Listing is inserted into local LAN database 3) Build new listing into an XML packet with CF's WDDX 4) Transfer new listing to a special Web page on Public site via CFHTTP, which deserializes the XML and inserts the listing into the public system database. (include some try/catches to make sure the handshake operates properly) Now, this sounds a heck of a lot easier than SQL Replication, and if you only need to basically keep a handful of table up to date, this is the way to go. HOWEVER, I haven't yet done this myself. This is just a theory, so I can't guarantee my understanding of WDDX/XML is perfect. If you do wind up doing this, let me know... I'd love to hear how it works out. Brian At 9:10 PM -0700 2/23/01, Jim McAtee wrote: > >I've got the following situation: > > > >A real-estate company wants us to develop a suite of browser based > >applications for managing listings, client contact management, billing, etc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Do outer joins work in MS Access 2k?
Please excuse this Access question on the CF list; this query concerns a CF site and I've run out of places to ask! I'm having a heck of a time with a complex query. I can't seem to get outer joins to work in Access, either using the *= syntax or the LEFT OUTER JOIN ... ON syntax. The same query will work either way against the same database running on a SQL Server 7 db. Unfortunately, this query needs to run against the Access version of the DB due to ISP hosting constraints. Our data model calls for storing bits of information (actually a mailing list) as rows related to a master row in another table, data that normally would be stored in fields in the master row. Problems arose when we noticed that a couple of fields were null in many of the entries, necessitating the outer joins to get the data we want. The query involves three tables:, RS_link (the master table), subcategories (a table that stores a "type" characteristic for rows in RS_Link), and data (a table that stores attributes related to a row in RS_Link each in a separate row). To produce a single record per RS_Link entry requires joins of several aliased copies of the data table, one column extracted from the data table according to each alias. The idea was to join RS_Link and subcategories together first, then tack on an aliased data table for every column needed via an outer join. Any thoughts would be greatly appreciated! Here's the query: --- SELECT D1.dt_text AS FirstName, D2.dt_text AS LastName, D3.dt_text AS Address1, D4.dt_text AS Address2, D5.dt_text AS City, D6.dt_text AS State, D7.dt_text AS Zip, D8.dt_text AS Country, D9.dt_text AS Phone, D10.dt_text AS AltPhone, D11.dt_text AS Fax, D12.dt_text AS Email FROM subcategories AS S INNER JOIN rs_link AS RS ON RS.subcat_id=S.subcat_id) LEFT JOIN data AS D1 ON RS.r_id=D1.r_id) LEFT JOIN data AS D2 ON RS.r_id=D2.r_id) LEFT JOIN data AS D3 ON RS.r_id=D3.r_id) LEFT JOIN data AS D4 ON RS.r_id=D4.r_id) LEFT JOIN data AS D5 ON RS.r_id=D5.r_id) LEFT JOIN data AS D6 ON RS.r_id=D6.r_id) LEFT JOIN data AS D7 ON RS.r_id=D7.r_id) LEFT JOIN data AS D8 ON RS.r_id=D8.r_id) LEFT JOIN data AS D9 ON RS.r_id=D9.r_id) LEFT JOIN data AS D10 ON RS.r_id=D10.r_id) LEFT JOIN data AS D11 ON RS.r_id=D11.r_id) LEFT JOIN data AS D12 ON RS.r_id=D12.r_id WHERE S.area_id=2 And D1.q_id=34 And D2.q_id=35 And D3.q_id=20 And D4.q_id=21 And D5.q_id=23 And D6.q_id=22 And D7.q_id=24 And D8.q_id=25 And D9.q_id=26 And D10.q_id=36 And D11.q_id=28 And D12.q_id=27; ----- Thanks, Brian _ Brian Panulla [EMAIL PROTECTED] Elmwood Media Group 814.238.6680www.elmwoodmedia.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
