Search results for query: *

Hi All,<br>I am trying to write a program to change the User Password information. I am not getting any errore but the password change dosen't work. I mean new password is not updated in the database. Please suggest me if i am wrong with the code. <br><br>&lt;CFQUERY NAME=&quot;GetPassword&quot...

Hi all,<br>I am trying to create a welcome screen after the user signs in.<br>I am trying to say &quot; welcome to #UserName#&nbsp;&nbsp;&quot;.<br>And it is giving this error.<br>Hope someone can help me on this.<br>Thanks in advance<br>Praveen<br><br>My code is:<br>&lt;CFQUERY...

I am getting this error. i think this might be coz of driver problem as i can't access the table. I tried all means like checking the ODBC in coldfusion and in my system. Still it doesn't work.<br>Can somebody help me with this.<br>Thanks<br>Praveen<br><br>ODBC Error Code = S0002 (Base table not...

Hi All,<br>I don't have any clue what this error is about. I am trying to insert a set of fields in to a table and got this error.<br><br>&lt;CFINSERT dataSource=&quot;PostYourHome&quot; tableName=&quot;Properties&quot...

I have problem making the links work. I am trying to implement the CFPage_thru custom tag given in allaire site.<br>I am not able to quite figure out why the current page link is not working? When i click on 2 or 3 then it doesn't work.<br>Praveen<br>This is my...

Hi,<br>Can i use multiple CFQuery tags in a single file? I have tried and its working but i didn't get the proper reselt.<br>I have a form which searches for houses based on some search criteria.<br>Fields are PropertyType, Bedrooms, Bathrooms, StateCode, PropertyPrice.<br>If my criteria is...

Hi All,<br>I want to create a Professional looking customized error page.<br>I mean when ever user submits incomplete form another page should be shown which looks like the original form showing some message(like &quot;Please enter the user name &quot;)below the user name text box.<br>I have...

Hi,<br>I got this message when i am trying to open my indexpage.<br>My server is working fine and there is no overload on the server.<br><br>Error Diagnostic Information<br><br>Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or...

Hi,<br><br>UserID is assigned by SQL server when each new user enters his data. I want to get the UserID assigned by server into another form .<br>I want to get the UserID into another form where i am inserting the details of AboutProperty.cfm in A table HomesOrLands. In Table HomesOrLands i...

Hi Can someone help me with this error:<br><br>ODBC Error Code = 23000 (Integrity constraint violation)<br><br>[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'UserName', table 'PostYourHome.dbo.Sellers'; column does not allow nulls. INSERT fails.<br><br>I...

Hi,<br>I am trying to query from multiple data tables in a single CFQUERY statement. I want to display fields from 3 different tables and need the recordcount of such a query.<br>Can someone help me on this.<br>Thanks<br>Praveen<br>

Hi <br>I have a problem. I want to access the number of houses in texas from my &quot;property&quot; table and display the recordcount besides Texas which is in the index page(main page).<br>example:<br>missouri(26)<br>Texas(15)<br><br>I want to display 15 beside texas.<br><br>can somebody help...

Hi <br>I need help with database search based on search criteria and also it should have previous and next links to access more records.<br>Can someone help me with this.<br>Thanks<br>Praveen

DM,<br><br>This is what i included as suggested by you.<br>&lt;cfquery name=&quot;Homes&quot; datasource=&quot;db1&quot;&gt;<br>&nbsp;&nbsp;SELECT * from Property<br>&nbsp;&nbsp;WHERE PropBedrooms &gt;= #PropBedrooms# and<br>&nbsp;&nbsp;PropBathrooms &gt;= #PropBathrooms#<br>&nbsp;&nbsp;and...

Hi<br>Can somebody help me with this. I am trying to get data into tables based on search criteria given in form. My form has 5 variables like state, bedrooms, bathrooms, property type etc..<br>I should be able to retrieve only those records whose state is texas and has 2 bedrooms and 3...

Hi All,<br>Can Someone help me with the Row wise display of a search criteria.<br>Thanks<br>Praveen

Hi All,<br>Can some one tell me how to display the system time on the Action display of a form. Suppose user posts his information in a form. Then i want to display the time of the transaction in the action page.<br>Thanks<br>Praveen