use regex or string_replace() to replace certain characters with something else
ie
$divcode = "<div id='mydiv'>";
$html .= str_replace("....",$divcode,$myhtmlinput);
Bastien
Cat, the other other white meat
sleipnir214
There are two solutions for paging with SQL Server
1. Use a stored procedure as indicated in the first post
2. Use the identity column as shown in the second post.
While most PHPers use MySQL which currently (in production modes) support SPs and therefore [perhaps] don't know...
A little more research also uncovered the identity column type...a sequential integer datatype that you coud use like a limit...this column could be added dynamically during execution and by using the id column in the where clause you should be able to implement some paging simply....
$sql =...
You could look at using stored procedures where you pass the offset and limit to the sp to get the appropriate data
google sql server recordset paging for more links
here is some code from winnetmag
Listing 4: SELECT_WITH_PAGING Stored Procedure
CREATE PROCEDURE SELECT_WITH_PAGING (...
Nah...its simple if you use tables
old_value = ""
while not rs.oef
response.write "<tr>"
if old_value <> rs("name") then
response.write "<td>" & rs("name") & "</td>"
else
response.write "<td> </td>"
end if
....
Bastien
Cat, the other other white meat
was looking your code....can you see the problem?
document.form1.submit.value=btn;
document.form1.submit();
}
</script>
<FORM ACTION="VTmain.asp?Option=LogIn" NAME="form1" METHOD="post" ONSUBMIT="return ValidForm();">
<input type=hidden name=submit1 value="">
Hint: the hidden field and...
have you tried
SELECT bulletinboard.*,bulletinreplys.reply FROM bulletinboard LEFT OUTER JOIN bulletinreplys ON bulletinboard.id=threadid WHERE (subject LIKE '%hello%' OR message LIKE '%hello%' OR reply LIKE '%hello%') OR (subject LIKE '%forumum%' OR message LIKE '%forumum%' OR reply LIKE...
Some recordset.count return -1 as the number of records. It depends on the type of cursor being used
Dim myArray() leaves the size blank....otherwise you set it to 0
Bastien
Cat, the other other white meat
use regex to replace the values...
ex...google the net to find more examples
Dim regEx, str1 ' Create variables.
str1 = "The quick brown fox jumped over the lazy dog."
Set regEx = New RegExp ' Create regular expression.
regEx.Pattern = patrn ' Set...
well, if you know the order of the record's fields comes back, you can display them in what ever order you want...
Bastien
Cat, the other other white meat
I am assuming that you are referencing the db value when writing the statement. Is there some criteria for a time when the prices are not to be displayed or is it for everyone?
Bastien
Cat, the other other white meat
if its coming from a hyperlink, use request.querystring("varName") to access the value from the link
then simply response.write it into the form
<input type="text" name="fname" value="<%=request.querystring("varName")%>">
Bastien
Cat, the other other white meat
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.