Database Functionality
Im trying to finish off this project, but obviously I need a way for them to edit the database through asp. Does anyone know a good place to get some code or tutorial help for this?
View Replies
ADVERTISEMENT
Script To Mimic Database Functionality
I need to read information from a delimitered text file and list it in a specified format on a web page.
I have no access to a database so have to use the method above, I am wondering though, how much of a strain this sort of function would be (ie. load times etc) for a very large list?
If someone could point me in the right direction of which functions i need to be learning about (Old hand at PHP brand new to ASP),
PDF Functionality
i have a server that has x number of pdf's. from time to time people are wanting to print one or more of those pdf's. right now they have to open up each pdf individual and then print. which can get annoying and time consuming after 3 or 4 pdf's.
i'm going to setup a simple screen where they can use a checkbox to select which pdf's they want to print, hit print, and then combine the selected pdf's into a temporary pdf where they can go through the process one time.
do yo all know of perhaps some functionality built into asp or some third party deal that will allow me to do this?
Functionality Of Sql 'like'
i have this search textbox and i want to search the likeness of the value
i've entered in the box i created a query but i notice that when i type small caps letters it returned no results...
no matching record but when i capitalized the first character records were found
e.g i type San the query returned results... i entered san and it returned nothing....this is my code "select * from profile where name='varname%'"
help please?
Search Functionality
I am really interested in creating a search the site.I am unsure how to actually approach such a task, but would rather do this using ASP, without the use of third party search tools, taht I know can be used.Can anyone give me some direction for actually developing one.I hope to add one to my site in the future, as the site will mainly be focussed towards offering tutorials etc, and it would be cool to actually have a serach utility, that could make things a lot easier for the viewer.
Any advice.
I have briefly looked at one offered on: http://www.stardeveloper.com/
But the complexity of it is overwhelming, and includes code that I dont think would be required for the search I actually have in mind.
Tear Functionality
point me to some code/pointers that would pull down the HTML of a page as a string, a little like ASPTear?
View Replies View RelatedSearch Functionality On Page
I made an application using asp using help from fellow members. This application allows user to download files uploaded through ftp through a web page. they can select the check-boxes and download all the files in a single zip file.
Now some users want that some search functionality should be put on so that they can type a part of file name and all the files having the searched words in their name should come on a separate page so that they can select and download in one go.
InterDev 6 IntelliSense Functionality Is Gone
InterDev 6 IntelliSense functionality is gone. IntelliSense is when you type Response. and it automatically pops up a menu with Response Methods:
Write
End
Redirect
...
Anybody knows which Windows DLL's or EXE are responsible for this functionality?
Excel Functionality In A Browser
I want to give Excel functionality. like copy/paste functionality in a web page and similarly I want to update the respective values at the backend after some action is taking by the user. like save/upadate data.
View Replies View RelatedProtect From SQL Injections Without Affecting Functionality
I am trying to figure out a good way to go by protecting from sql injections, but still letting people be able to post those symbols etc...
View Replies View RelatedAdd A Quick Search Functionality In ASP Or ASP.NET Page
I want to add a "quick search" functionality in ASP or ASP.NET page. I heard
we can use Microsoft Indexing Service to accomplish the task, but not sure
how to do it. Is this the correct approach? Code:
Detecting Session Functionality And Redirecting
I want to redirect users who DO NOT SUPPORT sessions to another page.
Think this will work? PSEUDO CODE:
-------------------------------------------------------------------
<asp vbscript>
<session("test")="true">
<if session("test")="true" then do nothing else
response.redirect(www.domain.com/nosessions) end if>
-------------------------------------------------------------------
This is setting a session state of "true", and I presume if sessions are
disabled for security reasons, that the site will redirect accordingly?
Search Functionality In ASP - Syntax Error
I am trying to create a very simple search functionality on my site. But I keep getting syntax error. Any one knows what I am doing wrong? Code:
View Replies View RelatedImage Search And Lightbox Functionality And Code..
I'm pretty new to this and im in the process of developing a site for a wildlife photographer in ASP and i need to implement an image search on the site including the functionality to add images to a lightbox etc. And to be honest i just dont know where to start... been searching and currently still searching .....
View Replies View Related"Email To Your Freind", Functionality
I have a main asp page, and i need to send the link to a friend, via an email. Say if i click the link "Email this to a friend", what i like is to make a pop up window and ask to enter username email address and freinds email address and click send, i need to send the link as i have on top ,is it possible to get the link which i have on top of the page as a paramter from the pop up window other than sending all values by url. Code:
View Replies View RelatedDatabase Limit - Microsoft JET Database Engine Error '80040e14'
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
Microsoft JET Database Engine :: Cannot Update. Database Or Object Is Read-only
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
Database 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.
How Do I Export Data Fom Local Database To Server Database?
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
Microsoft JET Database Engine , Database Or Object Is Read-only
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
Using Value From Database Updating The Database And Resuing The Value
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
View Replies View RelatedMany-to-Many :: Seperate Database Or One Database?
Products ---> Products|Customer <--Customer
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer
- Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to
overwriting or updating the remote database there are sometimes problems
with synchronizing data .....This seems to be a better solution?
Am I off base?
Web Database
does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.
I have built several websites before but none are database driven so is there any dummy proof versions?
Do While Out Of A Database
How do I do a Do While loop to display rows of information out of a database. Here's my code, and it seems like its in an infinite loop. Code:
View Replies View RelatedASP With Database
I have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.
I want users to be able to Enter and update only their data not other users data.
Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.
Database.mdb
I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.
Database Not
i have 2 tables and i only want the records where which arent in the one database eg.
table 1
idnum
1
2
3
4
table two
idnum
1
2
3
4
5
6
out of these two tables i only want from table two idnum 5 and 6 cause they arnt in the 1st table.
Job Database
They are on Windows 2000 IIS 5.0 and currently have an older version
of their job database using Access hosted on a Brinkster server.
The new server that they are on, when I contacted the host, they advised me
against creating any new applications using Access, as the server is not meant
for multi-users.
So, I am thinking that they need to get their host to upgrade to a SQL database
and have the job database developed using that.
My question to this forum is: What do you think is the best combination for
improvement here, SQL or MySQL or what, considering that their site is using asp
and hosted on Win2000 IIS 5.0?
Also, any recommendations on scripts that might be already available that could
be customised to their site?
Same Database
What we have is our own (in house) Windows 2000 Server which runs MS SQL for our data storage and we have writen our own VB6.0 Application which runs of the SQL DB to manange our stock, ordering, price's etc etc. Also we have our own Website with a Web Hosting Company which is also a Windows 2000 Server but can only Run access databases.
What we what to do is somehow have the Access database and the SQL database sync together to have some of the same data in both database's. But I don't know where to start.
Database
I have the following code to execute a SQL query.Code:
SQL = "INSERT INTO teams (`teama`, `teamb`, `pot`, `winner`, `finished`, `start`) VALUES ('" & teama & "', '" & teamb & "', 0, '', False, '" & gdate & "')"
teamrs.Open SQL, conn
all works fine.
I just want to know what result it gives.because once i add it, the form submits, and its a blank page. I want it so it does this Code:
if sql = worked
redirect
else
error
end if
so how can i make sure the query was executed successfully.
SQL Database
This is probably a stupid question (I'm good at those)...
I would like to enable a user to be able to browse to a picture on their local machine and upload that picture to a remote directory where it can then be displayed along with it's other pertinent data.
I thought it might be a good idea to use Front Page's "file upload" feature which includes a "browse" button and prompts me for a storing location - but I can't get it to work and am not even sure if that's its intended purpose.
So my question is two-part, what should my insert or update page look like regarding an upload process, and then how would I link to or display that picture?
ASP - Database
I have some questions in a database, i showed in the web page, for each questions i gave 3 (Yes, No, Not Applicable) options via select - option. when i get the variable with select name, it is showing with comma.
Example :
If they select for like that
Ist question - Yes
IInd question - No
IIIrd question - Yes
IVth question - Not applicable
The variable is coming like (Yes, No, Yes, Not applicable)
but i want to get with separate variables.
Best Database
What is the best database to connect to, and why?
View Replies View Related