MySQL Forums
Forum List  »  Newbie

Re: mysql query
Posted by: gurpreet randhawa
Date: June 30, 2005 07:23PM

My this problem has been solved thanks for this, i have another problem that i have apage called GETQUOTES.cfm where I get Quotes from database on regular basis and I have link to add them side by side, everything is displayed properly, the quote is inserted properly and when i try to view the quote, it diasply nothing , but when i try to run on my local machine it works very fine, what the cause could be????

The query are like as:

<cfquery datasource="dsn" name="ans">
select count(ID) as singlequote1 from q
</cfquery>

<cfquery datasource="dsn" name="Selected">
Select q.ID, q.Quotes, q.submitted_by, q.submitted_on
from q where ID = #RandRange(1,ans.singlequote1)#
</cfquery>
<table align="center" border="0">
<tr>
<td valign="top">Here's The Quote:</td>
<td><span style="color:red;">
<cfoutput query="Selected">
#Trim(Quotes)#
</cfoutput></span>
</td>
</tr>
<tr>
<td>Submitted By:</td>
<td><span style="color:red;"><cfoutput>#Selected.submitted_by#</cfoutput></span></td>
</tr>
<tr>
<td>Submitted On: </td>
<td><span style="color:red;"><cfoutput>#DateFormat(Selected.submitted_on)#</cfoutput></span></td>
</tr>
<tr>
<td><input type="button" value="Get New Quote" onClick="location.href='getquote.cfm'"></td>

Options: ReplyQuote


Subject
Written By
Posted
June 28, 2005 05:05AM
June 28, 2005 01:08PM
June 30, 2005 07:42AM
June 30, 2005 07:54AM
Re: mysql query
June 30, 2005 07:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.