Re: Verity and PDF
Ok, wow. That's a pretty rudimentary index ability then. I think I found the ticket though. It can save the index in a database format and then I can run verity on that. http://www.pdfstore.com/details.asp?ProdID=699 >I don't think it's possible to do that. You could cheat though. What >I'm about to describe is NOT something I've done. It's just an idea. > >Use CF8 and cfpdf (with DDX) to split the PDF into N pages. >Use names like original_N, where original is the original file name >and N is page no. >Index the pages. >When the user search returns a result for original_N, link them to >original and say "Found on page N". > >On Sun, May 4, 2008 at 1:19 PM, Richard Steele <[EMAIL PROTECTED]> wrote: >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304733 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP resolving URLS?
What code did you use? I've done this in the past with no problems. On Mon, May 5, 2008 at 6:08 AM, Nate Willard <[EMAIL PROTECTED]> wrote: > I haven't been able to get it to work. > > Any other ideas? > > Thxs > > > > > - Original Message > From: Mike Chabot <[EMAIL PROTECTED]> > To: CF-Talk > Sent: Saturday, May 3, 2008 8:51:32 PM > Subject: Re: CFHTTP resolving URLS? > > If you turn off redirection in the cfhttp tag you might be able to > pull the new location out of the cfhttp.responseHeader variable, such > as cfhttp.responseHeader['location']. You wouldn't end up at your > final destination though and would have to call cfhttp again to get > the content. If you do a dump of the cfhttp variable, and the new > location isn't there, then that data point isn't available. You could > always use an alternative to cfhttp, such as some Java function or > maybe calling a program like wget using cfexecute. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Java bytecode deployment for ColFusion8 App (Standard)
> I'd like to deploy such a web app using a hosting service on Windows.
> My own box is Windows XP Professional with IIS 5.x web server.
> Here're two problems:
> a) the {default} index.cfm is not working;
> b) an image file on the first page failed to be rendered.
> (Everything else seems working fine).
>
> The app uses cfwindow, cflayout and its family tags among others.
> Have you encountered similar problem(s)? Or am I missing something?
>
> Thanks.
> Resolved.
Never mind, I missed the image file.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304731
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: asynchronous call?
> i have a process that does take some time to do. i.e it gets > data out of the database, processes it, and then converts it > to a spreadsheet. the data and data processing can get quite > large and therefore i think the best way to do this would be > as follows: > > when the user clicks on a button to generate the spreadsheet > i call an asynchronous event that starts the build. the page > then reloads and continues to reload until either the > spreadsheet is available or the user goes away from the page. > while the spreadsheet is being built the page will inform the > user to be patient while it is being built. once the > spreadsheet is built then it is shown on the page and will > remain each time the user comes back to that page until they > click a renew button. which starts the process all over again. > > im hoping this will save the browser from timing out and will > allow the user to either wait or go off and do something else > while it is being generated > > is this possible with some form of asynchronous calls? is > this the best way to handle something like this? and if so > then what is the best way to handle the asynchronous calls? You can do this very easily in CF 8 using the CFTHREAD tag. If you're using CF 7 Enterprise, you could use an event gateway. In any previous version, you could have your code create a scheduled task. In any case, rather than having the browser wait around, you might have the user go do other things until the spreadsheet is ready. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: combining query column rows
> -Original Message- > From: Richard White [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 04, 2008 1:35 PM > To: CF-Talk > Subject: combining query column rows > > hi > > i have a query that returns x amount of columns (i wont always know how > many) such as follows: > > col1 | col2 | col3 > -- > 1 | 2 | 3 > > i need to run some code that combines the columns into one string, and > each value seperated by a space. > > so that a string would then equal "1 2 3" I'm reading this two ways... so here are two answers: ;^) 1) If you want the values of a column (a single column) then the ValueList function will do this. But I don't think that's what you want. 2) If you want the value of each row in the query as a single value then there are several ways (and several ways to combine these ways depending on how you need to do things): +) As you already noted you can loop over the query using the "ColumnList" (queryname.ColumnList will give you the list of column names) as your list in a CFLOOP. Use array notation to get the values (something like "queryname[CurrentColumnName][RowNumber]"). +) If possible it's probably easiest to do this in the original query. Depending on your DB you can concatenate multiple columns into a single return... something like SELECT COL1 + " " + COL2 + " " + COL3 AS MyValue. +) If you can't do it in the original query you might (should?) be able to do it as a query of queries. I'm just not sure if concatenation works in QoQ in this way (it does in others) but it would make the whole mess pretty simple. You could grab the ColumnList as above, replace the commas with the concatenation and generate the SQL you need use. For example the ColumnList: Col1,Col2,Col3 Could become, using a single replace of all commas: Col1 + " " + Col2 + " " + Col3 You can then build your SQL for the QoQ out of that (if it works). If the columns are consistent for some time (or multiple queries) you can also do this with the database itself - you need an initial query to get you the column list but then all your queries for data could use the concatenation to return the value as you want it. +) In the end what you really want is a pivot query: the same data you have "turned" 90 degrees such that ValueList() will return exactly the information that you want. If you're getting a lot of rows initially then you could pivot the query in CF (there are UDFs out there to do it) but again, if your DB supports this then you should do it there - SQL Server 2005 supports a "PIVOT" clause for example as do many others although they all have their own names (Access calls this "Crosstab Queries" for example). We could probably be more specific if you told us what DBMS you're using, how many rows you'll be returning and how often you'll be doing this. In the end, unless this is a performance hotspot then the simplest method (looping over the column list and creating the value) is probably going to be the fastest to develop/test and easiest to maintain. Jim Davis ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304729 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: combining query column rows
#replace(queryname.columnlist, ",", " ", "all")# Or #listChangeDelims(queryname.columnlist, " ")# ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Sunday, May 04, 2008 1:35 PM To: CF-Talk Subject: combining query column rows hi i have a query that returns x amount of columns (i wont always know how many) such as follows: col1 | col2 | col3 -- 1 | 2 | 3 i need to run some code that combines the columns into one string, and each value seperated by a space. so that a string would then equal "1 2 3" is there an easy way to do this or would i have to do it the complicated way by finding how many columns there are and then looping through the columns adding all the values to a string thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304728 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
asynchronous call?
hi, i have a process that does take some time to do. i.e it gets data out of the database, processes it, and then converts it to a spreadsheet. the data and data processing can get quite large and therefore i think the best way to do this would be as follows: when the user clicks on a button to generate the spreadsheet i call an asynchronous event that starts the build. the page then reloads and continues to reload until either the spreadsheet is available or the user goes away from the page. while the spreadsheet is being built the page will inform the user to be patient while it is being built. once the spreadsheet is built then it is shown on the page and will remain each time the user comes back to that page until they click a renew button. which starts the process all over again. im hoping this will save the browser from timing out and will allow the user to either wait or go off and do something else while it is being generated is this possible with some form of asynchronous calls? is this the best way to handle something like this? and if so then what is the best way to handle the asynchronous calls? i would very much appreciate your feedback thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304727 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: combining query column rows
> hi > > i have a query that returns x amount of columns (i wont always know > how many) such as follows: > > col1 | col2 | col3 > -- > 1 | 2 | 3 > > i need to run some code that combines the columns into one string, and > each value seperated by a space. > > so that a string would then equal "1 2 3" > > is there an easy way to do this or would i have to do it the > complicated way by finding how many columns there are and then looping > through the columns adding all the values to a string > > thanks > > richard hi, i managed to to find a solution by looking on cflib. there is a function called queryRowToList. i adapted it to use a space as a delimiter instead of a comma, and it works perfectly thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304726 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP resolving URLS?
I haven't been able to get it to work. Any other ideas? Thxs - Original Message From: Mike Chabot <[EMAIL PROTECTED]> To: CF-Talk Sent: Saturday, May 3, 2008 8:51:32 PM Subject: Re: CFHTTP resolving URLS? If you turn off redirection in the cfhttp tag you might be able to pull the new location out of the cfhttp.responseHeader variable, such as cfhttp.responseHeader['location']. You wouldn't end up at your final destination though and would have to call cfhttp again to get the content. If you do a dump of the cfhttp variable, and the new location isn't there, then that data point isn't available. You could always use an alternative to cfhttp, such as some Java function or maybe calling a program like wget using cfexecute. Good luck, Mike Chabot On Sat, May 3, 2008 at 11:31 PM, Nate Willard <[EMAIL PROTECTED]> wrote: > Hello all, > > Quick question. > > If I have a URL such as: > "http://feeds.feedburner.com/~r/Techcrunch/~3/283066435/"; > > Which resolves to: "http://www.techcrunch.com/2008/05/03/yahoo-responds/"; > > > When I call "http://feeds.feedburner.com/~r/Techcrunch/~3/283066435/"; in the > first CFHTTP, its automatically reloads the full techcrunch URL. > > Is there a way to obtain this final resolved URL? from the results of the > CFHTTP? > > Thanks, > N > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304725 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Java bytecode deployment for ColFusion8 App (Standard)
I'd like to deploy such a web app using a hosting service on Windows. My own
box is Windows XP Professional with IIS 5.x web server. Here're two problems:
a) the {default} index.cfm is not working;
b) an image file on the first page failed to be rendered.
(Everything else seems working fine).
The app uses cfwindow, cflayout and its family tags among others. Have you
encountered similar problem(s)? Or am I missing something?
Thanks.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304724
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Verity and PDF
I don't think it's possible to do that. You could cheat though. What I'm about to describe is NOT something I've done. It's just an idea. Use CF8 and cfpdf (with DDX) to split the PDF into N pages. Use names like original_N, where original is the original file name and N is page no. Index the pages. When the user search returns a result for original_N, link them to original and say "Found on page N". On Sun, May 4, 2008 at 1:19 PM, Richard Steele <[EMAIL PROTECTED]> wrote: > Hi Ray, > > I can get it to index various pdf documents in a folder, however I can't get > it to return the number of the page that contains the text. Is this possible? > If not, is there a third party utility that does this? It would be really > useful to be able to direct a user to the exact page that contains the search > item, otherwise they would have to read the entire document in order to find > the item that they are looking for. > > Thanks in advance. > > > > Verity determines how to parse the file based on the file type. You > > don't do anything special for PDF, you just index it like you would > > any other file or directory of files. I'd read the docs on cfindex > > and > > Verity. > > > > > > On Sat, May 3, 2008 at 4:03 PM, Richard Steele <[EMAIL PROTECTED]> > > wrote: > > > I want a user to search a pdf document (test.pdf) for a term and > > then go to the page that has that term on it. In Coldfusion 8, what > > would the cfindex tag look like to index test.pdf to do that? Is the > > page number returned? In other words, how can I link to that page? > > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304723 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Verity and PDF
Hi Ray, I can get it to index various pdf documents in a folder, however I can't get it to return the number of the page that contains the text. Is this possible? If not, is there a third party utility that does this? It would be really useful to be able to direct a user to the exact page that contains the search item, otherwise they would have to read the entire document in order to find the item that they are looking for. Thanks in advance. > Verity determines how to parse the file based on the file type. You > don't do anything special for PDF, you just index it like you would > any other file or directory of files. I'd read the docs on cfindex > and > Verity. > > > On Sat, May 3, 2008 at 4:03 PM, Richard Steele <[EMAIL PROTECTED]> > wrote: > > I want a user to search a pdf document (test.pdf) for a term and > then go to the page that has that term on it. In Coldfusion 8, what > would the cfindex tag look like to index test.pdf to do that? Is the > page number returned? In other words, how can I link to that page? > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: combining query column rows
You can do a list loop over recordset.columnList with CF. cheers, barneyb On Sun, May 4, 2008 at 10:35 AM, Richard White <[EMAIL PROTECTED]> wrote: > hi > > i have a query that returns x amount of columns (i wont always know how > many) such as follows: > > col1 | col2 | col3 > -- > 1 | 2 | 3 > > i need to run some code that combines the columns into one string, and each > value seperated by a space. > > so that a string would then equal "1 2 3" > > is there an easy way to do this or would i have to do it the complicated way > by finding how many columns there are and then looping through the columns > adding all the values to a string > > thanks > > richard > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304721 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
combining query column rows
hi i have a query that returns x amount of columns (i wont always know how many) such as follows: col1 | col2 | col3 -- 1 | 2 | 3 i need to run some code that combines the columns into one string, and each value seperated by a space. so that a string would then equal "1 2 3" is there an easy way to do this or would i have to do it the complicated way by finding how many columns there are and then looping through the columns adding all the values to a string thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304720 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Verity and PDF
-Original Message- From: Richard Steele <[EMAIL PROTECTED]> Sent: Saturday, May 03, 2008 17:03 To: CF-Talk Subject: Verity and PDF I want a user to search a pdf document (test.pdf) for a term and then go to the page that has that term on it. In Coldfusion 8, what would the cfindex tag look like to index test.pdf to do that? Is the page number returned? In other words, how can I link to that page? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Extending Application.cfc using mappings
Bad very bad:-) Your problem is that before the mappings for compents is created, the extends is trying to find that component components.ApplicationCMS. I have falling into this trap, and there is nothing you can do about it. Unless you have your mapping as predefined for the application. Sorry, but it is common sense why you are getting that error. -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 On Sat, May 3, 2008 at 12:25 AM, marc -- <[EMAIL PROTECTED]> wrote: > Hello, > I want to extend ApplicationCMS.cfc I have in an off-webroor folder. I am on > a shared hosting environment so I want to create my mappings in > Application.cfc, not in Cfadministrator. The mappings are not recognized this > way. When I create a mapping in the administrator (locally) it works. Here is > the setup: > > D:/www/components/ApplicationCMS.cfc > will be extended by > D:/www/wwwroot/ApplicationA/Application.cfc and > D:/www/wwwroot/ApplicationB/Application.cfc > > In D:/www/wwwroot/ApplicationA/Application.cfc I put: > > > > > > > > > If I request /ApplicationA/index.cfm I get > "Could not find the ColdFusion Component or Interface > components.ApplicationCMS." > Apparently the mappping is not working. Does anyone know how it can be fixed? > > Marc > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flex3 and CF 8 connection problem
Hello Mike, thank you. I will try it and come back to this list. Uwe > Regarding the version number, no you don't need to upgrade. Someone > reported a problem with Flex after upgrading. > The source of the problem most likely relates to your answer to the > second question. You should see a blank white page in CF 8.0.0. That > is what I see. > Is that a real URL, or did you mask it for purposes of reporting the > error? Meaning, do you work for abc.com? I'm guessing you don't, so > I'm hoping you tried that experiment using localhost or whatever your > dev server is. > You might want to Google around for "flex2gateway 404" or something similar. > You also might want to start with the Hello World Flex/CF tutorial app > that is on Adobe.com to make sure that works. > The "remote" access level should be an attribute of the functions you > want to expose that are in the CFC. > -Mike Chabot > On Sat, May 3, 2008 at 8:20 AM, James Holmes <[EMAIL PROTECTED]> wrote: >> Can you post the Flex code you're using to connect? >> >> >> On Sat, May 3, 2008 at 4:14 PM, <[EMAIL PROTECTED]> wrote: >> > Hi Mike, thanks for your questions. >> > I put the answers down below. >> > Uwe >> > >> > >> > > Quick questions. >> > > 1. Are you running CF 8.0.0 or 8.0.1 >> > CF 8.0.0 >> > Do you think I should install the updater ? >> > >> > > 2. What do you get when you enter that URL in the error message >> > > directly into your Web browser. Do you get a blank white page or >> > > something else? >> > I get a 404 error. I also noticed, that I get a 405-error using >> > RDS and I also don't know why. >> > >> > > 3. Is your CFC set to allow for remote access >> > I don't know. Where is this set ? I enabled remote LC DM on as below. >> > >> > > 4. Is Flex Remoting turned on inside of CF Admin? >> > Yes. >> > >> > >> > > What are some of the things you have tried so far that didn't work? >> > I also turned "Enable Remote Adobe LiveCycle Data Management access" on. >> > I played around with the file: \WEB-INF\flex\services-config.xml >> > without success. >> > >> > >> > > -Mike Chabot >> > >> > > On Fri, May 2, 2008 at 8:22 PM, <[EMAIL PROTECTED]> wrote: >> > >> Hi list, >> > >> I try to get Flex3 to get to be working >> > >> with CF8 and I can't figure out, why it is not working. >> > >> I get: >> > >> >> > >> faultCode = "Client.Error.MessageSend" >> > >> faultDetail = "Channel.Connect.Failed error >> > >> NetConnection.Call.Failed: HTTP: Failed: url: >> > 'http://www.abc.com/flex2gateway/'" >> > >> faultString = "Send failed" >> > >> >> > >> I google around tons of hints, but nothing worked. >> > >> S.O. who knows how to get it to run under Win2k and IIS 6.x ? >> > >> >> > >> Uwe >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> > > >> > >> > >> >> > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jTDS and Coldfusion, scope identity [heur SPAMTRAP]
Billy Jamme wrote:
> I'm wondering if anyone has any experience with the jTDS driver
> (http://jtds.sourceforge.net) and Coldfusion 8. I'm running this on Win2003
> box (32 bit), Cf 8.0 and sql server 2005.
we use it all the time. what version of jTDS? for cf8.01, jTDS 1.2.2 & sql
server 2000 that function works fine here:
SET NOCOUNT ON
INSERT a(testA)
VALUES ('c')
SELECT SCOPE_IDENTITY() AS id
SET NOCOUNT OFF
returns the identity value as expected.
> The ID column returns an empty string. However, if I switch back to the old
> data direct drivers the query returns an Id, as expected.
maybe the dsn's are pointing at 2 different DBs?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304716
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
