Type: Posts; User: Bill Wilkinson
Search took 1.45 seconds.
Oh, never mind, I see it. It's here:
WHERE c.RowID > $row_start AND c.RowID <= $row_end ORDER BY $sort $order
When you change sort order, you MUST go back to page 1. If you do that, I think the...
Throw it out and rewrite it.
How about we toss that code and do all the sorting in the browser?
Here's my first effort. It does *NOT* create links for either viewing the files or changing to other directories. Coming soon....
What do you mean by "only sorts the current page"?
You mean if you change WHAT you are sorting by? Or all the time?
This is a terrible idea:
$sql = "SELECT * FROM bids WhERE BidStatus=1...
But it is YOUR CODE (well, mine originally...but yours now) that is outputting that! Just STOP doing it!
Untested, but I think the only thing you need to change is this line:
I'm lost. If you want to list the files and show them as links, then how do you avoid the page being full of links?
Well, there is clearly one BIG bug in there:
SQL = "SELECT CustomField1 FROM KPUsers WHERE KPUser='" & name & "' AND KPPassword = '" & pwd & "'"
Response.Write RS("CustomField1").value &...
<a href="#" onclick="parent.location.href='logout.php';">Log Out</a>
SO show the XML. It probably doens't have such an element.
Correct. Read it carefully. It is saying "IF the file name is NOT index.html *AND* the file extension is NOT asp THEN..."
We could have done it the other way around:
If NOT( fname =...
For Each fileItem in curFiles
fname = fileItem.Name
fext = InStrRev( fname, "." )
If fext < 1 Then fext = "" Else fext = Mid(fname,fext+1)
' next line is an...
If you have control of the server, set it to allow all the possible debugging for ASP pages. Using the IIS control panel, select ASP and its properties and set (in Debugging Properties):
What does "turn it off" mean??
Stupid forum broke two of my [code] blocks in half.
So why not do the identical thing in PHP?
$sql = "SELECT BidID, COUNT(*) AS bidCount FROM bids GROUP BY BidID";
while ( ... loop on rows ... )
$bidid = $result["BidID"];
Or maybe you could do it thus:
<form action="whatever" method="post" onchange="this.form.submit()">...
SO that is trivial:
<form action="whatever" method="post" onchange="this.form.submit()">
<option value="Bid">Bid</option><!-- no...
<select name="SType" data-placeholder="Solicitations..." class="chosen-select" style="width:178px;">
<option value="">Choose one</option>
$tsql = "SELECT b.bidstatus, b.BidType AS sc,...
Ummm....yes. But it has nothing to do with PHP.
<form action="anotherpage.php" method="post">
There is a space in there: "...Prov ider..."
Is it really there? If so, that would certainly be a problem.
But why does this surprise you???
Surely you don't expect the production server to have the same disk drives and folders as are on your machine?
Try this in your web.config:
Answered. Have fun. If my answer doesn't work, post in the PHP forum on codingforums.com
Well, since that article showed making DATABASE results sortable, how can we guess what you did to make it read directories, instead? Or to make the files in the directories sortable? And as a not...
Answer right here on this site: http://www.4guysfromrolla.com/webtech/092201-1.shtml
The answer is from 2001, but it's still true today. You will have to find a third party component that is...
But I just reaslized this doesn't make a lot of sense. If a given order_id has 7 different products in the order, then your code will change quantity for all 7 products!
Shouldn't the code really...