how to extract a pic from ms access database.I used simple codes found online but it only gives me the binary codes not the pic itself.Wondering if anyone could help.I have already put the picture in the database.Now is extracting it.
View RepliesI have a set of code for displaying information from the database. However now i can only view text with no pics... what can i add in order to see pics together with the text and what data type should i put for the pics in the database? Code:
View Replies View RelatedMaybe a simple question but baffling me a bit. What I am doing is spanning a form across several pages, I was going to use session variables to collect the data but there are some 23 questions which can be of various lengths in answer form so I have opted to fill in a database entry. Multiple users may be logging onto the site at any one time.
What I need to do is create just one session variable - the user_ID which is allocated once the first database entries are initially added.
The question:If I am doing an 'INSERT into tablename values 1, 2, 3, 4 (thus creating a new record) how can I automatically get the user_ID (which is an autonumber field in the database) straight back out and allocate it to a session variable?) - we are trying to avoid a 'login' procedure
The codes below have some prob.It works well when the link as shown with the highlighted green is click as it passes the id to file.asp to show the pic in a new window.I now want it to show it in the same window itself.I mean i dun have to click the link to show the picture.It just will show the pic as shown in highlighted red.But all it comes out is the binary form. Code:
View Replies View RelatedIf you go to www.AstraAccounts.co.uk and click on any of the nav panel
folders on the left you may find that the images don't appear (white box
with red cross) for the tree-view items within these folders.
Yet if you right-click on any of these non-displaying images and go Show
Picture then these pics show without probs and will work for the rest of the
session.It only seems to be happening on IE 6 and intermittently at that.
Is it because I use ASP pages, although this particular nav bar is a
standard html page?Is it a recognised problem in IE 6?
Is there a way round it, ie via HTML code or a Microsoft patch?
made a page which should display one pic after another automatically as tho to say its generated from the database... not working tho
i have included some sample code as well in a txt file.
Basically I have created a small ASP site that allows a user to upload their
own pics via ASPupload so that they can be used on their site. I use a very
simple form with a INPUT file box to allow them to browse, select and upload
the picture. I then use ASPupload to save the file, get the file params and
then store these details in an Access DB as I can page through data far more
easily using a DB over a FileSysObj.
This works fine, but a number of users that use this site want to be able to
upload a large number of pics en masse. At this point, my knowledge of
problems to do with this are as follows:
a) ASPupload together with the trigger-happy ISP that I'm using means that a
total upload size at one time is really only about 800KB - 900KB at best
before the ISP triggers their script time out. Code:
I run my applications perfectly, can make changes to my database, but I cannot upload Documents or Pictures Etc.Etc.I was able to with my Windows ME OS. I now run Windows 2000.
View Replies View RelatedI have y pic's on the server and each time someone visits the site I want to display x of them randomly.
View Replies View RelatedI am trying to get random, unique pics to display but for some reason, I sometimes get the same pics showing twice.
could someone kindly shed some light on this Code: ...
Ok my boss wants to know if there is a way to display an unknown # of pics from folder onto a web page ASP using VBScript or JavaScript... doesn't really matter.
You don't know the names of the pics or how many are in the folder just that you want to display all the pictures in the folder...
how to parse a string for everything between the <p> and </p> tags .
View Replies View RelatedI MUST EXTRACT SOME ID FROM A SIMPLE TABLE.
I RECEIVE ID REQUEST FROM FIVE CHECKBOXS IN A RECORD SET
LIKE BELOW:
<input type="checkbox" name="id" value="<%=rs_s("id")%>">
HOW CAN I RECEIVE THE EXACTLY ID AND SUM IT BY A SQL QUERY??
I TRYED IN THIS WAY:
<%Server.CreateObject("ADODB.Recordset")
Set Rs_sum = Conn.Execute (" SELECT SUM(quota_sc) as quota FROM supplementi WHERE id IN (" & Request("id") & "); ")
BUT IT DOESN'T WORK.
I have a search engine and i want to extract only the URLs and the descriptions from the results which
come from the search, then i want to insert them into a database.How can i do that?
Trying to extract tab delimited data from several zipped .txt and .jpg archives into a database on the fly. I know there are some components out there to help with this, but this has to run on a regular web host (win2k) and I don't have the ability to install components on the server.
View Replies View RelatedI need to extract text from word document to asp page.
View Replies View Relatedhey everyone, does anyone knows how to extract data to extract from XML documents through the use of ASP or VB applications .
View Replies View RelatedHow do you fetch just the domain name part of a variable in a script?
The variable can be
http://www.domain.com/blahblah/whatever/page.htm
or
http://sub.domain.com/blahblah/whatever/page.htm
What I need is to extract just the "domain.com"
I need to find a script to extract a sentence around a keyword I search for in a MS Access Database.
View Replies View Relatedi want to extract out certain column from my table . can i do it using the checkbox . eg. when i got ten check box then when i select 4 of it . the selected 4 column will appear in my next page . can i do it this way ? or is there any other easier way ?
View Replies View RelatedCan anyone help me to write a scrip to extract an email address, name and address from an xml file.
A sample file looks like this:
Does anyone know how (using ASP & VBScript) how to extract the description from a webpage. I mean the meta description contained in the HTML (eg <meta name="description" content="description of website">).
View Replies View Related6408373-SALE-11/1/2007
From string, i want to extract "SALE"
How to do it using mid and Instr ?
Also,
6408373-DECLINE-11/1/2007
From string, i want to extract "DECLINE". How to do it using mid and Instr ?
I was wondering if anyone could help me out with extracting/stip an HTML file. I was thinking of using RegExp object in VBScript, but I'm not sure what is the correct pattern.
I would like to stip the HTML so I only get the content inside the <BODY> tag (<BODY> </BODY>) ...
Ive been searching the net now for about a week for someway to extract all of the links and images out of source code. I want to make a search engine. I can get the HTML of an entered URL, but now I need to EXTRACT all of the links e.g href, src and I want to place them into an access database.
View Replies View RelatedI currently have an excel flat database, it contains a computerName and it has a list of parts associated with it next to the cell value of computerName.There values that are offsetted to the right are the parts associated with the computer name. I was wondering through ASP could i have a dropdown of the computerName, when clicking submit it will find the offsetted values to the right.
View Replies View RelatedIs it possible to extract meta data (resolution, copyright, aspect ratio etc)from an mp4 file onto a web page? If so, how?
View Replies View Relatedi want to import data from excel and save it in sql server data base.my problem is how open excel file and read it cols by cols or rows by rows.
View Replies View RelatedI'm using the following method to retrieve the filname from a full server path:
<%
sub getfname(strPath)
Dim fName
fName = Mid(strPath,InStrRev(strPath,"")+1)
'fName = strPath
Response.Write( fName )
end sub
%>
However this only works on Windows systems as it checks for backslash. Is there a more generic way to do this, or should I check for both backslash and slash in the path?
Is there any way to extract the form elements' value without submitting the form. I want the value of the form element be used in the script written in the same page without submitting the form.
View Replies View RelatedI have several (well, several hundred) word documents. I need to extract information from each such as Author, Date Created etc... how would I go about doing this for a single document?
View Replies View RelatedI am trying to create a short description by taking the first 100 characters from my description field. My code is: Code:
shortdesc=left(objpagingrs("description"),100) & "..."
How would I make this take the first 100 characters (as it is now) but also take the next few letters until the next space. (so that I don't cut a word in the middle.)
I have a field in an access db which is of the data type Date/Time holding a date in the format, Short Date. Thefore it looks like 10/03/2004. The table holds a lists of events and I want to list them all by month breaking on the month as a header (and only listing for months which have events), like so:
MARCH
10/3/2004 Event Title
APRIL
1/4/2004 Event Title
JUNE
1/6/2004 Event Title
How can I display just the month from this field?