Return Entire Row(s
I know there's a way to do this - well 99% sure anyway - and seem to remember reading an article or tutorial about how to do it but I'm not having any luck finding it.
What I need to do (using MySQL & ASP3) is to find all rows with "X" as a non-unique ID - there may be 30 or so total - and grab them to be archived in a CSV file before deleting the record from a DB.The reason I want to avoid hardcoding the field names is that they're going to change with moderate frequency.
View Replies
ADVERTISEMENT
How do I get the entire URL?
<a href="trackingpage.asp?id=100&r=http://www.somesite.com?sc=news&art=45">Link</a>
On trackingpage.asp
----------------------
vTrackingInfo = request.querystring("id")
vRedirectPage = request.querystring("r")
problem is the &art=45 gets cut off.
View Replies
View Related
I need to do the following in the asp project.
The form contains the file upload component and textarea objects.
After the user uploads the word file (using file upload), the entire contents of the word file should be copied to the textarea and displayed.
View Replies
View Related
I have deployed a page with 3 frames of which one of them is a asp page.
Whenever the content of the page increases scroll bars apperar individually for each frame ruining the look of the page. I tried using tables instead of frames by giving "server.execute()" inside <td>.The drawback is that server.execute() doesnt accept absolute urls.Server side includes also cannot be used because the page to be loaded is decided dynamically based on the request.
How do i load absolute urls ...?
View Replies
View Related
I'm trying to write a function that allows a user to upload photos (like a photo album). I currently use AspSmartUpload as my upload component - but I only know how to upload one file at a time. Does anyone know if it's possible to upload an entire folder at once, or will the user only be able to upload one photo at a time?
View Replies
View Related
I have written an asp script to pull data from fields in an access database.However it is only displaying the first word of the string.Below is my code:
Response.Write ("<a href=residentialind.asp?add=")
Response.Write (rs.Fields("address").value)
Response.Write (">More information</a>")
how to capture the entire field.
View Replies
View Related
I'm developing a site under IIS and ASP. I want some help into a free solution to upload the content of an entire folder, even subfolders, to a web server from a client. It can be used ActiveX, COM or other type of components.
View Replies
View Related
I understand that I can use "Exit Sub" to terminate an subroutine. However,this does not prevent everything before the "Exit Sub" from processing and displaying. Now, if I can't determine if a certain condition is met or not met until later in the subroutine, how can I prevent any parts of the code from displaying?
For example:
Code:
Sub XYZ
Response.Write "Table Header"
For 0 to all user's online
If user's page is an product page, then
Response.Write Page_Name
Y = Y + 1
end if
next
If Y <> "" then
Exit Sub
End if
End Sub
View Replies
View Related
I use ASPUpload as a component to allow users to upload images to website. I did not find on ASPUpload.com website clear explanation on how to upload entire folder of images to website.
1) Is it possible to do using ASPUpload?
2) Could you recommend me other sites, articles etc to read about this problem (with code samples)? Or could you provide me an example of code samples.
View Replies
View Related
I'm currently doing a project that allow user to upload file to and download file from a server. my asp page funtion as file uploader can only upload a file at a time, and now the problem is when i try to upload an entire cd volume from a cd to a server, what i can do is just browse to individual file and upload it. i know that there's a virtual drive that does this function. but the project is host in intranet mode, so every user is accessing the server. and the virtual drive for server cost a lot. so can i know outside there's any coding or example or solution can help me with this upload entire cd volume problem?
View Replies
View Related
I am developing a site that has a mixture of both Static and databased content for which the client requires a site wide search to pick up on the text in the database and the text in the static html pages.
My original thought went to Index server? Does this still exist for Win 2003 Server? Are there any other similar server products? We can install what we like on the server, and obviously the cheaper/free'r the better! Or are there better solutions with some hosted search that can have a customisable results page?
View Replies
View Related
I have a page that adds data to an Access DB. When an employee adds a record I want to compare the phone number from the data they inputted to all of the phone numbers that are currently in the database for that field.
If the new phone number currently matches any record in the DB I want to have an alert that notifies the employee that a record with that phone number exists with the date that the first record was inputted and ask whether they want to continue and add the the new record or cancel the addition of the new record. Otherwise, I want the data to just be added. At this point I have a Case statement that will add the record after a submit button click.
View Replies
View Related
I am unable to downlaod entire folder at a time from the server using ASP i.e. all the files and sub-directory in that folder at a time, not by downloading individual files one by one .
View Replies
View Related
im using a asp file uploader to upload my file into a dedicated server. my uploader can only upload a file once a time. but my concern is if i want to upload the entire CD volume into server, i still have to locate the file in the cd one by one, is there any way or coding to allow entire cd volume to be upload at once?
View Replies
View Related
I have an Access Database; e.g., DB.mdb, which has 10 Tables; e.g., Table1, Table2, ..., Table10; in a directory; e.g., Directory1.
Using ASP copy method:
FileObject.Copy(destination[,overwrite]) I have made a copy of this entire database in another directory; e.g., Directory2.
The Tables from Directory2 has been and will be changed via writing new data into the 10 Tables in Directory2. I need to copy only one of the Tables, e.g., Table5 from the original database in Directory1, to the database in Directory2. Replace Table5 from the DB in directory2 witj Table5 from Directory1 without affecting other 9 Tables. How can I do that?
View Replies
View Related
I updated to aspx last three month,after developing serveral
applications,Idecided to downgraded to asp, following is my reasons:
1.in ASPX,the page format is hard to control,in ASP u can change every html
as u like ,but in aspx, a aspx control decide the page format,and its hard
to change the format.
2.ASPX is said to be faster that asp, but it is based on too-often
communication back to the server,for example,u click a radio a button,there
is new page request, but in reality,such a communication is
bandwidth-consuming and time-consuming. the user only need to submit the
form, and the exchange between IE and Server was minimazed.
the Speed of ASPX is not useful for most sites, for bigger sites, the speed
increase is singnificant,but for small sites with less traffic, the speed of
ASP is quite enough.
3.ASPX is based on Object Orinted Programming, but in most small sites,
Procedure orinted programming is used, we never build objects, and POP is
more efficient.ASPX is for three-tiered structure with a single layer of
business logic component, but in reality, most of us used two-tier
structure,that is Presetation layer and Datalayer, we can layout the page
and change the database in a single page, quite effienct too.
View Replies
View Related
I want to return a 404 response from an ASP script (IIS 5).
Response.Status lets me set the response string, but if I don't include any
HTML text myself, the result is an empty page.
Is there a way to 'redirect' it to the server's default 404 response, as if
the URI really doesn't exist, but without really redirecting it so the URL
isn't replaced in the browser's address bar?
View Replies
View Related
I am trying to replace a huge chunck of code that currently I incorporate
with an #Include directive. The program rarely has to flow through that
code, so I thought it would be better if I used Server.Execute.
I found I can pass data TO the called asp file by creating an HTML <input>
and erading it after I get there.
However, I also need to read back ONE variable that the called file must
set. I cannot figuer out how to do that. My backup positions are (1) I can
keep on using the #Include technique, and (2) I can use a database to bridge
the gap.Isn't there a way to carry data BACK TO the calling asp file FROM
THE CALLED asp file?
View Replies
View Related
I am using a stored procedure to insert set of values to a table.I am generating or calculating the value of the primary key and inserting that record and i need that value to use in my application so is there any possibilty to return a value from storedprocedure to asp application.
what i am using to do is creating a #temp table and inserting that value in the sp and then opening that value in the asp application and droping that table, but i hope it is not a efficient method.
View Replies
View Related
When a user logs in, I want to redirect them to the page that they were previously on. How do I do that? I already have the login page working. I just need to edit the redirect part.
View Replies
View Related
The code bellow functions well. However if I want to obtain a return
value using the code bellow, how is it done? Code:
View Replies
View Related
I'm assuming this can be done, but I can't seem to get it to work... I'd
like to easily return a single value from a sql statement, something like:
"intNewItems = conn.execute "SELECT COUNT (ItemID) WHERE ItemDate = Date()",
where conn is the connection object, etc. What am I getting wrong?
View Replies
View Related
There is an access database and asp page .That asp page opens connection with that database,And opens a recordset online..
Is there any way that this opened recordset can be returned to Vb6 application which requested that Asp page to open connection and recordset and return some result.
View Replies
View Related
How do I return the true/false value from the database to be either a checked or unchecked box using ASP?
View Replies
View Related
I just need to understand how the following line returns its values.Code:
Dim Var
For each FormElement in Request.Form
Var = Request.Form(FormElement)
Next
You see say I have 5 form elements on an html form.
Element One
Element Two
Element Three
Element Four
Element Five
I know that it is not checking the names of the elements and producing the results in that order, I know its not running through the Elements top to bottom on the form.
So in what order does FormElement return the values and based on what?
View Replies
View Related
am trying to make a carriage return of the following:
Mailer.BodyText = "From: " & Request.Form("FRM") & VbCrLf & VbCrLf & "Message: " & Request.Form("MSG")
but it doesnt work.
when i received the email on my mailbox, the format is all in one line, like this:
From: John Message: Test message only
but i would like the "Message:" to appear in the second line.
View Replies
View Related
in my SQL select query I have a LEFT JOIN between 2 tables that returns a
value if the data from table 1 is present in table 2, below
dbo.booking_form.COLL_CONTACT_TEL = dbo.tblFlag.TelNoMo OR
dbo.booking_form.MOBILE_NO = dbo.tblFlag.TelNoMo
Problem is that if the COLL_CONTACT_TEL and MOBILE_NO are both present in
table 2 it returns the record twice in the asp page repeat region.
View Replies
View Related
I want to create a pop up asp page something like:
popUp('myasp.asp',.......)
and when the user closes the popup can I return a value. So sudo code would be like
myJavaScript
int temp = popUp('myasp.asp;,.............. /* Temp is the value returned by myasp.asp
set some textfield to have value temp.
end
Is this possible?
View Replies
View Related
When should we use 'return' in a function to return the result versus 'FunctionName = result'
View Replies
View Related
Code:
function findcinemaid(nameofthecinema)
findcinemaid = "select cinemasid from cinemas" &_
" where brand = 'tgv' and cinemaplace2 like '"&nameofthecinema&"'"
set cinemaidfound = objconndb.execute (findcinemaid)
optainedcinemaid = cinemaidfound("cinemasid")
end function
tgvcinemanamexcel = "[1u_f$]"
cinemaname = "ONE UTAMA"
findcinemaid(cinemaname)
response.write optainedcinemaid
if I put response.write inside funciton it will display the cinemaid properly but if I put it outside , it wont display
View Replies
View Related
My SQL statement won't return results where any field in a record is blank. What can I do to fix this?
strSQL = "SELECT * FROM newarchive WHERE Program_Title LIKE '%" & program & "%' AND Year_Aired LIKE '%" & yearA & "%' AND Sponsor LIKE '%" & sponsor & "%' AND Month_Aired LIKE '%" & monthA & "%' ORDER BY ID"
It gets its values from a form where some fields can be left blank. If the record itself does not have a blank field, the search will pick it up. But if the record contains a blank field, then it won't be selected unless it matches the Program_Title data.
View Replies
View Related
How can i get the autonumber(primary key value) from the specific rows when i just insert it.Example
i just insert the member information.
sql="INSERT IMTO register(user,password,address) VALUES (shujuan,841218,singapore)"
so how can i get the primarykey for this row after i just create it.
View Replies
View Related
I cannot use the OpenTextFile method, it's never return and I get no
error message! Setting Response.Buffer=False, has no effect. No matter
if I use it ForReading or ForWriting, it never return. In the following
code, the problem occurs at line 3.
aFileName = Server.MapPath("WEB_PROD.htm")
set fs = server.CreateObject("Scripting.FileSystemObject")
set fso = fs.OpenTextFile(aFileName, ForReading, False)
s = ts.ReadAll
ts.Close
set ts = nothing
Response.Write s
View Replies
View Related