Hi,
I have a mail merge document in MS Word 2003 in which I use several form fields to be filled manually as well.
When a user opens the document (well, the system generates the document), they have to enable macros for the merge to work, once the data is retrieved from external source and...
I don't think you can pass text to a stored procedure. Use varchar.YOu can send up to 8000 chars through it.
Have a read of this: http://www.sqlxml.org/faqs.aspx?faq=42
You are either the slave of what made men or what men made.
select a.thiscol, b.thatcol, c.thiscol from table a, table2 b, table3 c, table4 d where a.thiscol like '%this%' or b.thatcol like '%that%'
That way you can build big query. There are other ways to achieve what you are doing. Like keeping keywords in a separate table with a reference to the...
I am working on a website and they require a dropdown menu. I have created the menu and it works perfectly fine.
Now I want to give it some kind of effect so instead of appearing all at once, it appears slowly (eg slides).
How can I do it in javascript.
You are either the slave of what made...
I found a solution guys... thanks.
I used another field and put all the keywords "with a preceding and trailing spaces" like " adsl modems netcomm " for a record that had Netcomm ADSL Modems. Doing search of that new field rather than title.
You are either the slave of what made men or what...
Hi everyone,
I am having difficulty with writing a search function that searches the database for keywords. How can I write a sql query so that it returns those records that contain the keyword as a word not part of a word.
I tried using wildcards like this
select * from mytable where title...
I have build a very primitive dropdown menu that is displayed onMouseOver and goes hidden onMouseOut.
It works fine, except the fact that IE gives an active x warning once the page is loaded. There are other websites that have similar kind-a stuff but doesn't get blocked. Can anyone tell me...
try casting
<% if cdbl(minspend) < cdbl(producttotal) then %>
do stuff
<% end if %>
Cheers,
Hameed
You are either the slave of what made men or what men made.
It really depends on what sort of details you want and also of the page layout.
....... why do you want to display content of another page. I am sure there is a better way of accessing those info.
You are either the slave of what made men or what men made.
You have two options: reset to radio_disabled to zero length string "" just before the if statement
<%
radio_disabled = ""
if CStr((Recordset1.Fields.Item("lock").Value)) = "Locked" then
radio_disabled = "disabled=true"
end if
%>
or write the whole HTML tag inside the if statement:
<%...
Try the following. This way, it will also show number 1 even if it is deleted.
<%
sCaseID = 1
Do Until objRs.EOF
If sCaseID < cint(objRs("CaseID")) Then
For i = sCaseID to cint(objRs("CaseID"))
Response.Write(i & "<br />")
Next
End If...
do until recordset.eof
response.write(recordset("CaseID") & "<br />")
this_caseid = cint(recordset("CaseID"))
recordset.movenext
if this_caseid > cint(recordset("CaseID")) + 1 then
for i = this_caseid+1 to cint(recordset("CaseID")) - 1
response.write(i & "<br />")
next
if...
<%
if CStr((Recordset1.Fields.Item("lock").Value) = "True" then
radio_disabled = "disabled"
else
radio_disabled = ""
end if
%>
<input type="radio" <%=radio_disabled%> ....>
This will only disabled if the Lock variable is true.
<table>
<tr>
<td><!--#include file="left.asp"--></td>
<td><!--#include file="main.asp"--> </td>
<td><!--#include file="Right.asp"--> </td>
</tr>
</table>
Of course you can layout the table as you wish.
Hegards,
Hameed
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.