Large Database Fetch
I've a large database that I am working with. The problem is right now I've so many sample data in the datbase all the testing data in it. I want to clear the database and reset the AutoNumber so that it starts at 1 and goes up by one.I know that its possible in Access and I've done it before, problem is the tables have relationship and lots of them.
the way I know to rest the AutoNumber require me to break the relationship but it will take very long time for me to rectreate them again and I might not get them same at the end.Is there a way to rest the AutoNumber without having to break the relationship?
View Replies
ADVERTISEMENT
I have a webpage with a form. This form submits data that goes to a mdb file
(id (AutoNumber), name, email contry etc.). I would like to make another
page where I can type the ID number and it will show all the fields only for
that id.
View Replies
View Related
There are 26 prizes available in a competition a client is running and he wants to be able to select these at random.
I thought the best way of doing this would be to construct a simple ASP page which displays 26 random records from the database.
The fields I wish to display are called name, email and address, and these are located in the table called Competition (this is an MS Access db).
View Replies
View Related
principally I'm a photographer, and in the absence of any image galleries I could make sense of I created my own asp pages in Dreamweaver displaying images from a path stored in a database. These can then be paged through, all done using server behaviours in Dreamweaver. However, because I wanted to include some text next to my images, again a field in the database, I have to scale them down. I would like to give the user the option to see a larger version of the image on display, preferably in a pop-up window that is then closed by the user before they continue scrolling through the images....
View Replies
View Related
I am looking for a script in which I can replace any word in one table
(which corresponds) to other table with a link....
To for example when the name Bill Clinton is in a large piece of text in
TABLE1 and Bill Clinton is a row in TABLE2 then I want Bill Clinton in the
text to display as a link leading to a page where there's more info on Bill
Clinton from TABLE2
I was thinking something allong the way of: Code:
View Replies
View Related
I have an asp page that returns a table from my database. Only about 6 columns from the table are shown on this page. I have the ID column set up as a dynamic link to a 'details' page, so a user can view the rest of the record data.
My database has been growing rapidly, and now when the page is run i get the error "page cannot be displayed".
I believe this is due to how large my database table is because if i delete records the page works fine, as it did when the system was first running. Right now there are 4600 rows in the database and will be growing.
How do I fix this problem, I cannot get rid of any records.
Oh yea, and if i delete the line of code that contains the link, the page works fine and shows the entire table.
Here is the code for the link:
<A HREF="details.asp?<%= "JOB_NO=" & rsResults.Fields.Item("JOB_NO").Value %>"><%=(rsResults.Fields.Item("JOB_NO").Value)%></A>
View Replies
View Related
I'm trying to insert this text into a memo field:
Set cnn = CreateObject("ADODB.Connection")
str = Server.MapPath("database/alumni.mdb")
strDB = "Provider=MICROSOFT.JET.OLEDB.4.0;Data Source=" & str
cnn.Open strDB
Set rst = CreateObject("ADODB.Recordset")
sql = "INSERT INTO tblMessage (MessageID, UserID, PostTypeID, Subject,
DatePosted, MessageText, Active) Values ('" & vMessageID & "','" &
vUser & "', " & vPostType & ",'" & vSubject & "','" & vDatePosted &
"','" & vMessageText & "',0)"
rst.Open sql, cnn, adOpenStatic, adLockOptimistic
vMessageText = "This is a test just to see if it will blow up on a
large comment. Just testing again. Don't mind me."
Can I put this into my database field or is it too much and if not,
how do I solve this issue. I need to be able to post messages and
input for large fields.
View Replies
View Related
What are the ASP codes required to fetch files from a remote location?
View Replies
View Related
query = "SELECT table. * FROM table where table.lastname=" & lname
How can I fetch all the rows with the lastname field equals to lname variable?
View Replies
View Related
I want to save the details of phases. On selecting a phase, there are 3 columns, task ,start date, end date in a row. Next to it, a button'Add task' is displayed. on clicking this, another row appears below. When i click submit, the data is saved if the following condition is truw: The end date should not be less than start date. how do i retieve the data of all the rows.
View Replies
View Related
I'm trying to make a sorting feature for my site which will allow the user to click a drop down menu, click the item they only want displayed, click a button, and then the results will only display that particular item.
I also would like the drop down menu to auto-fill because there are about 20 different categories available. is there and easy way to do this?
View Replies
View Related
I have an excel file having textfields, I want to get its value from the ASP page. What is the way to get it?
View Replies
View Related
I need to run a query to get records with date within 30 days from current date.What I used to do with SQL server 2000 was the following:
Date30More = Date+30
MPQry = "SELECT * FROM SOP_T where Rev_Date < '" & Date30More
This stops working with Oracle because Rev_Date in Oracle is in the format of "DD-MON-YYYY HH:MM:SS PM". Therefore, I received an error message as the following:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Oracle][ODBC][Ora]ORA-01858: a non-numeric character was found where a numeric was expected
View Replies
View Related
im trying to connect to access and display some infor. from table. but it cant work, many errors occur, saying dat the<%language="VB" runat="server"ris not found in server. what i need to add in so that i can take infor. from acess? some codes.?
Example:
SELECT* FROM Detail... bla... bla... bla...
View Replies
View Related
A client has an OLE field called Signature in an Access database. The field contains a GIF image of a scanned signature (that a product has been received). How can I show this on an ASP page?
View Replies
View Related
I'm looking to display information pulled from a database based on information the user puts into a text box. The user will enter their sales rep number and I want to hit a table and return their name as soon as they tab off of the text box.
View Replies
View Related
whenever i fetch any numeric value, having a zero at the end, e.g. 32080, from a database with a recordset object, i find that the value becomes stripped of the last zero, i.e. it becomes 3208.
View Replies
View Related
I have a text box when user type (Name) on it and push search button,if
database has this name information such as(phone, address,...) comes in
several text box, if user want to update these information ,change text
in text box and save it, I couldn't write the update code for this
situation,
View Replies
View Related
Is it possible to fetch data records from other website and store in a
database dynamically.
I mean to say i want to fetch data from a yellow pages website. showing records of different companies.
i.e, http://www.website.com/data.aspx?Co...1&DirectoryID=2
So, now I want a script which goes on this path and copy data after that go on next page which is CompanyID=3&DirectoryID=2 and follow the procedure.
View Replies
View Related
The following is the error keep getting while running web application.
Tools used: HTML, ASP, DLL's(written in Delphi).
Application Error: dllhost.exe - Application Error
---------------------------
The instruction at "0x00000000" referenced memory at "0x00000000". The
memory could not be "read".
Click on OK to terminate the program
View Replies
View Related
I am updating over 100 fields in 7 tables with SQL in VB 6.0. The values will mostly come from check boxes. Do I need a VB variable to hold each value for my SQL query?
Also, what is the syntax for skipping an optional field? Do I just skip it and use comma's? I will never know which values are checked off so I cannot write code that will only insert my true values.
View Replies
View Related
we are rebuilding a large website and we want to make sure it doens't lose it good ranking within the search engines. So we were thinking of using 301 to tell google where the pages have moved to.
The problem is I'm not really sure where to start to impliment something this. We have a website that has 26,200 indexed pages, so I need to come up with somekind of solution that would work across the board.
View Replies
View Related
I am a PHP programmer and trying to do a site in asp but one feature I can't figure out how to do in ASP is large variables.
In PHP it is
$fullpage = <<<EOT
THE ENTIRE PAGE OF HTML
EOT;
EOT can be anything it just uses that as a starting and ending point so I can have quotes, apostrophes, variables etc inside the page. Is there any way at all to do this in ASP? Code:
View Replies
View Related
I need to populate a select form input (combo box) with about 22,000 rows of data. This is taking an unacceptable amount of time to load. And this data is only going to grow in the future.
I'm using a stored procedure to get the data. Not sure if that's the most efficient. I'm using classic asp. I'm open to any suggestions because I'm not even sure where to look to get options.
View Replies
View Related
I am trying to upload large images ( around 4 mb) from the server to show on
the client. Currently I'm using an http handler to do it and breaking it
into chunks sending it 1 mb at a time. Sometimes I'm getting errors, like
the page won't load. Any solutions on how this is done right?
View Replies
View Related
I am trying to do some calculations on large numbers (ie
7,768,489,957,892,578,474,792,094 / 12,280) and no matter what I do it
doesn't get it quite right. Its always somewhere between 10 and and 5000 out
:(
I have a suspition is could be down to one of the number functions I am
using along the way but im not sure.
View Replies
View Related
I am using forms authentication to protect all content as described in the
kb article below.
http://support.microsoft.com/defaul...kb;en-us;893662
This works fine except for files that are larger than about 40 or 50mb at
which point the user gets a 404 error and the httperr log indicates
connection_dropped status.
This is a w2k3 server with SP1 and all security patches installed.
Has anyone seen this before? I have been reading various posts online but
none seem to fit this symptom. Also have tried tuning various meta-base
properties to no avail.
View Replies
View Related
It seems to me that I generally use two types of Functions:
Type #1-Ones that any page on my site might use
Type #2-Ones that only a single page would ever use
Logically, it seems that I should put the Type #1 functions in the GLOBAL.ASA file and the Type #2 functions in the pages that use them. I would like to, however, just go ahead and include ALL of my functions in the GLOBAL.ASA file.
Comments on this? Is this a good idea?
View Replies
View Related
when creating a webpage that must display a large result set, the page load time is unbearable. Unfortunately, there are a lot of records and they all need to be displayed, at once, on this one page.
To reduce file size, I have minimized the amount of HTML tags used to dislay these records. My only other idea is to write javascript matrix to hold the data, and then to use dom to create the page on the client side. Are there any tried and true ways of speeding up page loads?
View Replies
View Related
I am attempting to use the technique in KB 812406
(http://support.microsoft.com/?kbid=812406) to transfer
large files via Response.OutputStream.Write.
It works GREAT in in debug mode. But whenever I set
debug="false" in the web.config file clients get cutoff after about 1.5 minutes.
There is no error raised the client simple gets an incomplete file.I've tried playing around with various timeout settings in web.config and in IIS with no luck.
View Replies
View Related
I am currently developing a download centre for a hardware manufacturer which has alot of firmware and other software available to it's clients. Most of these are less than 10mb and with their internet connection I'm thinking a browser upload through the admin tools will be fine. However there are files on the current site of up to 100mb, how would be best to handle uploading these?
I was thinking maybe an ftp component would handle bigger files better than an normal http upload? Does anyone know of any components that allow some kind of background uploading so they can continue to use the admin for other tasks while this continues?
Or just any other suggestions full stop! Maybe I would need to come up with some way of taking them out of the system and loading a windows ftp with the correct directories etc.. predefined?
View Replies
View Related
I want to count number of data available depending upon the conditions in the large database the database table rows are approximately 3 lakhs and there are multiple table to be searched and records need to be displayed in ASP pages.
Kindly suggest the best scripting method as i am always getting error like "Script Time Out" Error in Active Server Pages (ASP)
please suggest how to avoid or in sql server i can create some pre defined script and just call from asp pages
View Replies
View Related
I am creating a dynamic website using ASP and an MS Access backend DB. I am a little confused with how to go about things and am now facing the following problem. I want a large volume of text to be loaded dynamically on my page but don't really understand how i should be storing this text as the database fields will only hold a max 255 chars.
Obviously this is not large enough to store all of the text i may need and so where should i be storing the text? The only idea i had was storing the text in an external text file to which i point to with the database field (i.e. database holds the path to the txt instead of the actual text itself).....is this possible? or more to the point is there a better way? How would this normally be accomplished?
View Replies
View Related
