[KCFusion] MS SQL and query results

If I query a MS SQL7 db asking for a record that matches two values, and the query can't make a match, is there a way to tell which of the values didn't match? In the query below is there a way to know that the username matched but the password did not? The only way I can think of to do this is

RE: [KCFusion] MS SQL and query results

You may want to reconsider letting someone know that the account # is right but the password is wrong. -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 11:03 AM To: KCFusion (E-mail) Subject: [KCFusion] MS SQL and query results If I query

Re: [KCFusion] MS SQL and query results

Assuming the username is unique, simply drop the and Pword = '#Trim(form.Pword)#' and check the password match at the application layer. --Daryl - Original Message - From: Keith Purtell [EMAIL PROTECTED] To: KCFusion (E-mail) [EMAIL PROTECTED] Sent: Monday, January 28, 2002 11:02 AM

[KCFusion] Text box value

Is there a way to show around a value inside a text box? __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments

RE: [KCFusion] Text box value

You might be able to use double quotes in your input statement. Try value=#value# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Laire Josh Sent: Monday, January 28, 2002 1:47 PM To: KCFusion (E-mail) Subject: [KCFusion] Text box value Is there a

RE: [KCFusion] Text box value

You could alternate single and double. input type='text' name='blah' value='SomeText' Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the

RE: [KCFusion] Text box value

textarea name=text#Value#/textarea don't forget to strip them in insert :) Or if you want to keep them. Use this tick/quote insert trick cfset locGoodChars = quot;,acute; cfset locBadChars = #chr(34)#,#chr(39)# // use this in your insert statement... '#trim(ReplaceList(form.text,

Re: [KCFusion] Text box value

Use the htmlEditFormat() function around the value. Value=#htmlEditFormat( someValue )# This will replace the double quotes with quot;, as needed. --Daryl - Original Message - From: Laire Josh [EMAIL PROTECTED] To: KCFusion (E-mail) [EMAIL PROTECTED] Sent: Monday, January 28, 2002

[KCFusion] How to preserve lt; and gt; strings... (was: Text box value)

Use the htmlEditFormat() function around the value. Value=#htmlEditFormat( someValue )# This will replace the double quotes with quot;, as needed. Speaking of htmlEditFormat, here's a question for you. Say you've got a textarea where users can enter a combination of text and html. A

RE: [KCFusion] How to preserve lt; and gt; strings... (was: Text box value)

Daryl, Well slap my a** and call me Sally. I'm actually doing this with ASP at the moment, and since it doesn't (to my knowledge) have a fn comparable to htmlEditFormat, I didn't actually try it with CF first. My apologies to the group. :) BTW, the ASP fix is like so: Replace(objRS(body),,amp;)

RE: [KCFusion] How to preserve lt; and gt; strings... (was: Text box value)

htmlEditFormat() fn is a little too //several// for my purpose, severe sorry, ron __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives

Re: [KCFusion] How to preserve lt; and gt; strings... (was: Text box value)

Not to be too picky about things, but (imho) there is no such thing as a 'legitimate' angle bracket in an input's Value attribute. According to the HTML spec, angle brackets, quotes, and ampersands in html tag attibutes 'should be' replaced with their entity references (granted, the angle