Store A Database Value In A String
I have run a sql select statement against a table in my database. I would like to store the value retrieved in a string. How do I do that? So far I get an empty string when I run my code.
View Replies
ADVERTISEMENT
Store String
when i perform this:
Session(username) = Request.Form("username")
and print it out:
<%= Session("username")%>
it doesn't output anything.
Store Connection String
I usually create a db.asp file, and include it on each page i need the db connection, but where do you think is the best place to store the db connection? anything a bit more secure?
View Replies View RelatedStore Hyperlink Into A String
this gives an error;
strLink = "<a href="member.asp">Member Area</a>"
how do i fix it??
Store String Variables
I have a variable which has numbers like these
str="01-11-23-034"
i want 01 to be saved in one variable,11 to be stored in second variable and so can like
str1="01"
str2="11"
str3="23"
str4="034"
Store Info In Database.
I have made a registration form for adding my friends information in a
database. The problem is that I want to connect the persons with companies
in the same database. I wonder how i could connect a person to several other
id's in a table.
I wonder if I can make a string in the database that holds all the id's
separated with , for example....?
the string would then look like this:
1,4,6,22,56
for example...
But how can I then open this string and separate the numbers from the , ???
Get Image And Store In Database
How do I take an image from <IMG SRC>? Meaning I can not insert the image with the Upload method, I have to take it directly from the <IMG SRC>. Is there a possible way to do that?
View Replies View RelatedBest Way To Store Database Password In ASP Application?
I am new to ASP security. I want to know what is the best way to store
database password in ASP application? Or if there are any places to
store in IIS? I tried to store the password in VB DLL file, but looks
like when I open the DLL file, I can still see the plain text password.
File Upload And Store Name In Database ?
I am trying to write a page that lets the user upload any file to a server and this also stores the name of the uploaded file in to the database.
So far I'm not having much luck. I am a novice with ASP and really could do with some help.
I have been trying to use ASP Upload but it is confusing me as how to modify the script to allow me to insert the name of the File in to the database.
Here is my form page (you will notice this checks to see if we are uploading/editing or deleting). Code:
Upload File To Server And Store Name In Database
I want to be able to upload a image to a directory called 'images' on my server and also save the file name in a database. is there anything out there that does this without a COM?
View Replies View RelatedDatabase Connection String To MySQL-database On A Different Server
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
Connection String For A MySQL Database Needed
I'm trying to get asp to conect to a MySQL database, I've tried copying a few examples online that I found [there doesn't seem to be many!!] and I always get a 500 error with the code below. what am i doing wrong? any examples of a working connection string anyone could show me would be fantastic.
View Replies View RelatedRetrieving Data From Database - Query String?
I have this page with photo thumbnails that are clickable. Each photo has corresponding info saved on a database. When the thumbnail is click, im trying to show the data in an asp page called info.asp.
sample:
Photo #1 when clicked goes to: info.asp?no=1
Photo #2 when clicked goes to: info.asp?no=2
so on so forth..
the database fields are:
no
picname
date
details
I only know how to display ALL info from a database.
But i cant figure out how to display SPECIFIC info triggered by a query string. Example. Photo #1 is clicked. I only want the data that corresponds to Photo 1 to be displayed. How can i do this?
How To Access An DSN In The Connection String To SQL Server 2000 Database?
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={SQL Server}; Server=;Database=pubs;Uid=myUsername;Pwd=myPasswor d;"
Instead of database, how can I set the DSN in this connection string?
DSN is DSNName. I am trying to connect to a SQL Server 2000 database.
Store Procedure In ASP?
how to write store procedure in asp?
View Replies View RelatedASP Store Locator
where I can find an asp script(free) to do a store locator.
I've only been able to find 2 on the web, and they are both at a cost.
Online Store
I am looking for some ASP - SQL server 2000 online store application that i can buy for my company. This store is completely internal for the company and will be on our intranet server and will be utilized by the company employees to buy company merchantdize.
Also at this time there will be no credit card processing as the amount of purchase will be deducted from the payrol. I will be needing the shopping cart and product view. Later if we provide the credit card processing, we have already installed PayFlowPro from verisign and do creadit card procesing on our main site.
Does any one know such application that i can integrate with our style sheets and general layout?
Store A Query
I am using ASP and VBScript to access an Oracle database and display query results to my users.
However, my query is huge! and I want to keep the query separate from my ASP/VBScript code.
How do I store the query on one page and then call it from another page?
Store New Values
I have this problems regarding "storing New values into session".
Take the "online movie tix booking" as an exmaple. When i click on one seat, beside storing the seatNo into a session, i also want to store the number of seats he has clicked throughout. How can store the incremental of seats clicked into a session by overriding new Values
Store Procedure
i am stuck with the following error message
"Application uses a value of the wrong type for the current operation."
did anyone know the reson this occur?
just because of my store procedure....
ASP & Store Procedure
I have an ASP page and a Store Procedure but I keep getting this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'sp_searchresultsZIP' expects parameter '@xDateTo', which was not supplied. Code:
No-cache Vs No-store
what is the diference between these two cache control header.no-cache and no-store.I have read the w3.org explanation.So lets say I am using only no-cache ....my understanding is thatnothing is cached and nothing is writen to disk.but what happens when we use no-store....i think..nothing is written to disk but it could be cached.
Now my question where is this cache located...is it only in memory ?....if it is written to disk how log is it there and when does it gets cleaned.Is no-cache more secure than no-store ..why?
Store Picture
i found that OLE won't work. any alternative?
View Replies View RelatedStore A Recordset
I'm having need of storing a recordset in a collection tempararily. Can I hold a record set in a Collection object ? Any other way of holding a record set is also works, except arrays.
View Replies View RelatedStore The Values
I've been trying to come up with a method to store the values of a forms variables into a basic text document, say a notepad txt file. Its a windows server that im experimenting with and I'm not experienced with PHP, so im trying to find a easy way via either javascript/html or asp.
View Replies View RelatedHow To Store A Value From A XML Into A ASP Variable
how do i store a value from a XML into a ASP variable
I need to store "maxpage" into a variable call "totalpages" in my asp file...how do i do it?
Store Locator
Does anyone know where I can find on the internet a good web site that can explain to me how a Store Locator script works using ASP and a SQL database?
View Replies View RelatedStandard Way To Store The Dates
when some data is being into my database, most of the data is recieved from a form.
2 of the fields are dates, but looking at the db (access) the dates are stored in the '38307' format. - is this the standard way access stores dates?
Now, how do I get it to enter /todays/ date into a column? I thought it would be something like
RecordSet.Fields("LogDate") = today()
but this is wrong, right?
The other date, is to be entered by the user in the form. Now, what is the best way of going about this? It will be in a different column, but in the same format. My default, it would be 'todays' date, but needs the option of being changed. Any ideas? Code:
Store The Path Of Image
I created a table with varchar field where i want to store
the path of an image.
I will then use this file to retrieve this image on my
browser. Everything goes fine when i use a simple html
command as :
<img src="C:InetpubwwwrootMyWebimagesone.jpg"
height="200" width="200">
this is a hard-coded path. Hence no problem.
But when I store in the database path value: Code:
How Can I Store Images Using ASP & SQL Server!!
i m creating a site using asp in which i will collect user details, means their names, address, other information along with their pictures, so please can any one help me by telling how can i strore pictures in sql sever using asp. in very long detail. and how can i retrieve snaps from data base to display on the pages.
View Replies View RelatedHow To Assign A Variable And Store The Value Getting From XSL
I would like to ask izzit correct that assign a variable in asp and store the value select from XSL list at below: (in my asp page) Code:
View Replies View RelatedStore Session Variable In DB
I want to maintain the user's session variable while moving from HTTP to HTTPS. I learned that you can store the sesison in a database, but I am not sure about the logic behind this method.Can someone explain how this works?
View Replies View RelatedStore Locator Script
i'm looking for a script that would help me establish "find the nearst store to you, enter your zip code here" i have the DB with the stores and i want some help with this?
View Replies View Related