RE: Character Code....
It's 39. You can use the ASC() function to have it tell you. #asc()# -Original Message- From: Kevin Mansel [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 2:40 PM To: CF-Talk Subject: Character Code does anyone know the chr() code for the apostrophe? ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Passing SP params to CFReport
MS SQL Server 7.0 -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:55 PM To: CF-Talk Subject: Re: Passing SP params to CFReport What database? I had a similar issue with Sybase ASA 7.02. Upgrading to 7.03 solved it. Todd - Original Message - From: "DJ Riebesell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, August 17, 2001 2:16 PM Subject: Passing SP params to CFReport | I have tried every variation I can think of to pass in three parameters into | a CFReport for use when it calls a stored procedure. | | I can call a report that requires no input fine and it displays fine. | | When it requires parameters it seems to just hang, like the server is | prompting for them only I obviously can't see the prompt. It just gives me | the forever spinning globe in my browser. | | CF5 with Crystal 8. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
Passing SP params to CFReport
I have tried every variation I can think of to pass in three parameters into a CFReport for use when it calls a stored procedure. I can call a report that requires no input fine and it displays fine. When it requires parameters it seems to just hang, like the server is prompting for them only I obviously can't see the prompt. It just gives me the forever spinning globe in my browser. CF5 with Crystal 8. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: SQL Server Authentication
Enterprise manager cannot connect via TCP/IP I receive an error: Not associated with a Trusted SQL Server Sql Server Network Utility shows Named Pipes, Multi-protocol, and TCP/IP -Original Message- From: DJ Riebesell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 10:26 AM To: CF-Talk Subject: RE: SQL Server Authentication Actually, to ammend that. It doesn't appear I can connect with Enterprise manager via TCP/IP -Original Message- From: DJ Riebesell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 10:02 AM To: CF-Talk Subject: SQL Server Authentication I am trying to set up a datasource connection to a SQL Server. The test server works fine, the production fails. The DS connection is set up on the production server just as it is on the test server. All SQL Server settings that I can see are the same. I can log into the production server with the username and pw over a TCP/IP connect and named pipes with Enterprise manager. I have tried with and without USE TRUSTED CONNECTION. I have gone into the Win2000 ODBC tool in the control panel and tested the connection there. It tested out fine. Have used the SA account and another account. I tried putting the username and password in just the CF Datasource setup, just the templates query, and both. The server is on the same lan as the CF server. Nothing seems to get around this error: ODBC Error Code = 28000 (Invalid authorization specification) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'. It seems to never allow the username to get through. Ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: SQL Server Authentication
Actually, to ammend that. It doesn't appear I can connect with Enterprise manager via TCP/IP -Original Message- From: DJ Riebesell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 10:02 AM To: CF-Talk Subject: SQL Server Authentication I am trying to set up a datasource connection to a SQL Server. The test server works fine, the production fails. The DS connection is set up on the production server just as it is on the test server. All SQL Server settings that I can see are the same. I can log into the production server with the username and pw over a TCP/IP connect and named pipes with Enterprise manager. I have tried with and without USE TRUSTED CONNECTION. I have gone into the Win2000 ODBC tool in the control panel and tested the connection there. It tested out fine. Have used the SA account and another account. I tried putting the username and password in just the CF Datasource setup, just the templates query, and both. The server is on the same lan as the CF server. Nothing seems to get around this error: ODBC Error Code = 28000 (Invalid authorization specification) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'. It seems to never allow the username to get through. Ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
SQL Server Authentication
I am trying to set up a datasource connection to a SQL Server. The test server works fine, the production fails. The DS connection is set up on the production server just as it is on the test server. All SQL Server settings that I can see are the same. I can log into the production server with the username and pw over a TCP/IP connect and named pipes with Enterprise manager. I have tried with and without USE TRUSTED CONNECTION. I have gone into the Win2000 ODBC tool in the control panel and tested the connection there. It tested out fine. Have used the SA account and another account. I tried putting the username and password in just the CF Datasource setup, just the templates query, and both. The server is on the same lan as the CF server. Nothing seems to get around this error: ODBC Error Code = 28000 (Invalid authorization specification) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'. It seems to never allow the username to get through. Ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Easy question I think:
Return Even Items select * from table where item % 2 = 0 Return Odd Items select * from table where item % 2 != 0 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 11:31 AM To: CF-Talk Subject: Easy question I think: Can anyone give me a sql statement that tells me if a value is odd or even? select * from table where ? ~~ 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
RE: all this email
I think there must be something wrong with your email address. It doesn't end in AOL.COM. hehe snicker snicker giggle giggle. :) -Original Message- From: Jason Santerre [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 2:22 PM To: CF-Talk Subject: all this email please stop sending me all this info... i'll search your site for it if i want it .. thank you.. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ 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
RE: Brain isn't working yet...
Allow action -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:56 AM To: CF-Talk Subject: Brain isn't working yet... I'm trying to provide functionality to a select group of people on a specific subnet. What I'd like to do is something along the lines of.. Allow action The thing being they use dhcp to allocate IP's and the address could actually be any of the block. Is there a wild card I can use? or some other way to not specify the last number? Marcus ~~ 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
