|
<%
strSearch = "SELECT Brief,Area,City,Country,Telephone,File Data" & "FROM [registration] " & "WHERE City LIKE '" & Replace(request.Form("txtsearch"), "'", "''") & "%' "
rsSearch.open strSearch, strconn, 3,3
%>
<%
On error resume next
rsSearch.movefirst
while Not rsSearch.eof
%>
</p>
<table>
<tr>
<td height="20" colspan="4" class="fontbold"> <%=rsSearch("Brief")%> </td>
</tr>
<tr>
<td width="217" height="20" class="font"> <%=rsSearch("Area")%> </td>
<td width="99" class="font"> <%=rsSearch("City")%> </td>
<td width="94" class="font"> <%=rsSearch("Country")%> </td>
<td width="225" class="font"> <%=rsSearch("Telephone")%> </td>
<td width="200">
<%
if not (rsSearch.EOF and rsSearch.BOF) then
PicSize = rsSearch("File Data").ActualSize
if PicSize > 0 then
Response.BinaryWrite rsSearch("File Data").GetChunk(rsSearch("File Data").ActualSize)
End if
End If
response.End
'if rsSearch.eof then
' respond.end
' else
'Response.ContentType ="image/jpeg"
'Response.BinaryWrite(rsSearch("File Data"))
'end if
%>
</td>
</tr>
<%
rsSearch.Movenext
%>
<%
Wend
%>
modified on Thursday, October 14, 2010 9:07 AM
|
|
|
|
|
Your formatting has caused the entire forum to not display correctly. Please remove it or format appropriately.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Don't know - but you might want to look at your first line:
dababy wrote: strSearch = "SELECT Brief,Area,City,Country,Telephone,File Data" & "FROM [registration] " & "WHERE City LIKE '" & Replace(request.Form("txtsearch"), "'", "''") & "%' "
getting rid of the totally unneccesary concatenations, you end up with
strSearch = "SELECT Brief,Area,City,Country,Telephone,File DataFROM [registration] WHERE City LIKE '" & Replace(request.Form("txtsearch"), "'", "''") & "%' "
which will cause an error at ...File DataFROM [reg...
|
|
|
|
|
Actually this is where I am having issues with see below.
<%
if not (rsSearch.EOF and rsSearch.BOF) then
PicSize = rsSearch("File Data").ActualSize
if PicSize > 0 then
Response.BinaryWrite rsSearch("File Data").GetChunk(rsSearch("File Data").ActualSize)
End if
End If
response.End
if rsSearch.eof then
respond.end
else
Response.ContentType ="image/jpeg"
Response.BinaryWrite(rsSearch("File Data"))
end if
%>
|
|
|
|
|
Well can't you at least use the error object to display/log the error number/description, to at least give you some idea of what the problem is (and something to Google for)?
|
|
|
|
|
and what made you decide PRE tags aren't good any more?
|
|
|
|
|
Column names should not have spaces in them. If you insist on doing such a horrible thing you need to enclose the column name in square brackets [] when you do queries.
|
|
|
|
|
I think you must check out that,if you want to retrieve any image from database you must save that image any temporary location. then you can specify the location of thumbnail..
All the best
Anupam Singh
|
|
|
|
|
How to set background image for iframe? If set, it is not working in IE. But works with Mozilla and Google Chrome. How to fix bug in IE for displaying background image in iframe.
M Sworna Vidhya
|
|
|
|
|
Going from memory here, but it may help...
In most browsers you can set the background CSS property to transparent...but not IE. In IE you must also set the background of the content/page loaded in the IFrame to transparent.
I would assume that you need to set the background image property for the content/page that you are loading inside of the IFrame, not the IFrame element itself
|
|
|
|
|
I have a Header that in CSS is font-size:xx-large, however I want it to be larger.
How do I set a larger font?
(Using Visual Web Developer 2008)
.header
{
margin-left:auto;
margin-right:auto;
width:1024px;
height:100px;
background-color:#AAFBF9;
padding-top:5px;
font-size:xx-large;
text-align:center;
}
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
|
I had tried that, had no fun.
EDIT: Sorted!
Forgot the PX!
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
modified on Monday, October 11, 2010 4:53 PM
|
|
|
|
|
Dalek Dave wrote: Forgot the PX!
Dave
Find Me On: Web| Facebook| Twitter| LinkedIn
CPRepWatcher now available as Packaged Chrome Extension, visit my articles for link.
|
|
|
|
|
You can set a larger size using something like px (pixels). This isn't a great solution however, as it's not very friendly for scalable pages. I would use something like em instead. You can set it to something like font-size:2.2em.
|
|
|
|
|
I would also suggest setting your body font-size to 62.5%. This way, it is easier to convert between em and px.
For example:
body{
font-size: 62.5%;
}
p{
font-size: 1.2em;
}
|
|
|
|
|
Thanks, good idea.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
|
Always a good idea
|
|
|
|
|
I've created a seperate html files for navigation, content and footer. I want to club those files. All the navigation, content, footer files resides in the same directory where the index.html file resides. I want to include the above mentioned html files inside the index.html. I have tried using the following in index.html file
<!--#include virtual="topbanner.html" -->
I also tried using the asp code which also fails. I tried with asp by changing all the html file extensions as .asp. Then i tried to place the following asp code in index.asp file as
<!--#include file="topbanner.asp" -->
Kindly solve my problem. This is an urgent thing to do for me.
M.Sworna Vidhya
|
|
|
|
|
Is it a full html file that you're trying to include? If so, this will cause you a problem as you should only try and import the relevant elements, and not the full page. BTW - convention seems to be to use .inc extension for include files.
|
|
|
|
|
The only way I can think to do it outside of something serverside would be to use javascript with a document.write()....maybe this will help http://www.cryer.co.uk/resources/javascript/script4.htm[^]
I would use php to do what you want on the server side of the fence. PHP has a number of related function like include() that I use to seperate my html output into different sections. I do this by making a number of small php files like....
header.php
menu.php
footer.php
these can all contain the basic html output like this example
header.php
-----------
<html>
<head>
<title>My Site</title>
<body>
.....end header.php
AND
menu.php
-------------
<div>
<ul class='menu'>
<li><a href=''>Link 1</a></li>
<li><a href=''>Link 2</a></li>
</ul>
</div>
hope that helps...
AND
footer.php
-------------
</body>
</html>
......end footer.php
NOW you just call these from a page script like this.
index.php
--------------
include('header.php');
include('menu.php');
// start page content....
// end page content....
include('footer.php');
|
|
|
|
|
How does it fail? Does it cause an error?
Have you checked to make sure your server is configured to handle SSI?
I thought that html files had to end with .stm in order to get IIS to parse the includes.
|
|
|
|
|
Hi,
I am wondering if anyone can point me at an example of a CSS layout that I cannot get to work for the life of me, despite reading countless tutorials. (Give me a bit of C++ and I'm usually okay, but I have to admit CSS still feels like a black art to me).
The layout I am wanting is:
- whole layout centred
- 3 colums
- 2 side-columns fixed width, centre column variable (but with a min and max maybe)
- all 3 columns same height regardless of amount of content
I really don't want to resort to tables, but I just can't get this to work with divs and CSS.
Please help!
Best wishes, Patrick
|
|
|
|
|
Can you post your code so we can take a look at it?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
