Table Size
I have these two tables in a SQL database. i.e. tbl_A and tbl_B
I need to create an ASP page that will tell me the size of each table and then the combined size of both tables.How do I accomplish this?
ADVERTISEMENT
File Size And Folder Size
I'm using Windows 2000 server n IIS I'm Using FileSystemObject of ASP in Server Every File and Folder has 2 Size when we get properties of any 1 actual size and Size on Disk.now my problem is when i get the file size from ASP object it give Size value but when i try to get folder size it gives size on disk and both values are different.
I'm creating a size to access limited size to upload files so i just check the folder size and then get size for those which are going to update by user then i will less those size to actual folder size to get remaining size.
How To Transfer Records From One Table Of A Database To Another Table In Another Data
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
How To Open A Recordset For A Table Has Space In The Table NAME?
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
Table Inside A Table Update To DB
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
Copying From Table 1 Inserting In Table 2
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies View RelatedBookmarking A Position In A Table <table>
Have an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
How To Get Data From A Table Into A Table Form?
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedBest Method Of Updating Table From 2nd Table
I have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
How To Get Size
how can I get size a file from any sites.
http://www.domain.com/fileblablabla.zip
I want to know what the size of file is by using ASP..
is there any way ?
or is there any free component ?
(But it must cancel immediatily after getting the size of file..
because maybe its size can be 50 Mb
Url Size Limitations??
I am using variable passing through the url, and as it is getting larger, I am finding that occassionally some values are getting trimmed. Is there a limit to how long a url can be?
View Replies View RelatedFONT SIZE
how can I get different font size in the form method "select", "input"
instructions working under ASP? because when I check with the browser is too
big in the table.
============================================
<FORM method="post" action="../gallery/default.asp">
Select a category:
<SELECT name=""CategoryID">
<option" value="">Select Your Gallery</option>
<OPTION value="3">Digital Package</OPTION>
<OPTION value="6">others</OPTION>
<OPTION value="5">test</OPTION>
<OPTION value="4">Traditional Package</OPTION>
</SELECT>
<INPUT type="Submit" value="View Photos">
</FORM>
==========================================
Image Size
I am having a problem with this code. The problem I am facing is that
the first image is displayed in its original size. But when I click the
next button, the next image not displayed in its original size, but
being displayed as 100 x 100 pixels, same goes to the 3rd picture and so
on. Code:
About Max Size Of Cookie
cookie has a limit size? if yes, how big?
View Replies View RelatedGetting Image Size
I only need to know the height and width of the image.
It doesn't seem to be as easy as php's "getimagesize($imgFile);" method.
<%
'Copyright *c* MM, Mike Shaffer
'ALL RIGHTS RESERVED WORLDWIDE
'Permission is granted to use this code
'in your projects, as long as this blah
'copyright notice is included
function GetBytes(flnm, offset, bytes)
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFTemp = objFSO.GetFile(flnm)
lngSize = objFTemp.Size
set objFTemp = nothing
Set objTextStream = objFSO.OpenTextFile(flnm,1)
strBuff = objTextStream.Read(offset - 1)
GetBytes = objTextStream.Read(bytes)
objTextStream.Close
set objTextStream = nothing
set objFSO = nothing
end function
function lngConvert(strTemp)
lngConvert = clng(asc(left(strTemp, 1)) + ((asc(right(strTemp, 1)) * 256)))
end function
function lngConvert2(strTemp)
lngConvert2 = clng(asc(right(strTemp, 1)) + ((asc(left(strTemp, 1)) * 256)))
end function
function gfxSpex(flnm, width, height)
fileT=split(flnm,".")
if fileT(1)="gif" then
Width = lngConvert(GetBytes(flnm, 7, 2))
Height = lngConvert(GetBytes(flnm, 9, 2))
elseif fileT(1)="bmp" then
Width = lngConvert(GetBytes(flnm, 19, 2))
Height = lngConvert(GetBytes(flnm, 23, 2))
elseif fileT(1)="png" then
Width = lngConvert2(GetBytes(flnm, 19, 2))
Height = lngConvert2(GetBytes(flnm, 23, 2))
end if
gfxSpex=true
end function
if gfxSpex("images/urlogo.gif", w, h) = true then
response.write w & " x " & h
end if
%>
Which is a little bit shorter, and seems to work ok so far, but isn't there anything easier, like php's "getimagesize($imgFile);"?
Listbox Size
I have a drop-down with 40 option values and only one option should be selected of the 40 options. The list size should be 1.
When I click on the list, it drops down 30 options (a very long list) with a scrollbar for the last 10 options.
Is there any way, when I click on the list it drops down only 5 options (as if the list is of size 5) and allow a scrollbar to browse the remaining 35 options.
Code is:
<select name="deplist" id="deplist"
<option value="Commerce">Commerce</option>
<option value="Instru">Instrumentation</option>
... similar such 38 options
</select>
Setting Img Size
I need to set the image size in the following line. When I try to set the
img to 75x75 I am getting an error. The line I'm having problems with is :
Response.Write "<a href='" & imageFilePath & strPicArray(0,x) & "'><img
src='" & thumbFilePath & strPicArray(0,x) & "'width="75" height="75"></a>"
Limiting Size
How does one limit the amount of characters being entered into a <textarea>. I know we I can maxlength="50" an <input>, but what about a textarea?
View Replies View RelatedMaximum Size
I need a general code for limiting an image size in pixels.Uploaded Images from people may not be larger on width than 400 px.
If so than a script would minimize them to 400 but if they are 260 px then they of course appear in 260 px
How Do I Get A File Size
How do I find out the size of a file. I can get listing of files in a
directory but I cannot figure out how to get the file size also.
Here is what I have so far.
<%
Set MyDirectory=Server.CreateObject("Scripting.FileSystemObject")
Set MyFiles=MyDirectory.GetFolder(Server.MapPath("test"))
For each filefound in MyFiles.files
Response.Write filefound.Name & "<br>"
Next
%>
I don't have any books for reference here. Can someone point out a good
online source?
Asp Get Image Size
i have a page that displays an image. the image path is a variable passed in the url link. eg. enlarge.asp?picture=http://www.hey/.com/you.jpg
and the window it opens works. but id like to try and get the enlarge as to get the height and width dimentions so i can call a new window to opena popup and ill dynamically have the images dimentions to scale the popup to fit.
and right after the javascript calls a new popup window itll use a close window function. and since it happens before the head tags it should be seamless as if i had a regular link calling a popup.
ASP File Size
Is there any limit of file size or lines of code in asp.
View Replies View RelatedSize Array
I have a variable named numdata that contains an integer value. Now I want to create an array with the size of numdata. Example: If numdata is 25, then the array should be test(25). Unfortunatly test(numdata) doesn't work.
View Replies View RelatedGet File Size!
i am using the file type input and an asp upload component to save the file from client machine to server machine. if user type the file name or path that doesn't exists, the upload component still create a file on the destination but that file is empty. Now, how can i determine the size of the file saved on destination.
OR
its alternative is that can we restrict the user to type the path and file name. i mean the text field is disable and only browse button is used to select a file.
Adding Size
I have just finished building my first shopping cart in asp and MS Access. Originally the shopping cart was to be built for products with no size and colour, however as usual the goal posts have moved and I now need to incorporate a size and colour option for each product. Could anyone explain to me how I can go about doing this i.e. adding the different sizes and colours in the admin website and then linking them to a specific product when it is displayed on the products page? I know they both need to be in a dynamic drop down box when displayed on the products page within the shopping cart, but I am just wondering how to read the correct values out from the table depending on which product is being displayed. I have a normal products table at the moment with general fields i.e ID, name, description etc.
View Replies View RelatedFont Size In ASP
i have created a login page which works great except it looks really ugly in IE. I am trying to make the text size smaller but i have tried everything and it doesnt work. below is my code:
View Replies View RelatedUpload Size
I wnat to upload file in large size ...
View Replies View RelatedSize Of Recordset
I am trying to create an array the size of my recordset. I tried the following:
dim myArray(get_notes.recordcount)
I then figured that it was that I needed to initialize this after I got the records. This did not work either, I keep getting the following error:
expected integer constant
Any Ideas on how to create this array to the correct size that is dependant on the the size of the recordset?
Size Of A File
given a filename on the server, how would you use the filesystem object to determine its size?
View Replies View RelatedPop Up Form Size
I have an asp app that uses several pop up forms. They are supposed to be larger forms, but on some machines, all using IE, they display a lot smaller than they should be. Here are some of the behaviors that I am experiencing:
* It doesn't seem to matter what resolution the client is set for.
* It seems to come and go.
* It's not consistent across operating systems or browser versions; all
client machines use IE 5.5 to 6.0.
Where can I set the size for popups so that I can be sure they will display at their proper size?
File Size
How can I get the size of a file using Scripting.Filesystemobject. If not,is there a way that I can using ASP?
View Replies View RelatedMax Size Of Array
Is there any limitation to the maximum size of an array in ASP?
View Replies View RelatedSpecify Size Of New Window
I have a link which on clicking will go to a new page as in my example below. however i want to open it up in a new window and also specify the size of that new window. how can i do this in ASP? i dont wnat to use Javascript cause I have an ASP variable, strURL, and need to send that to the page. Code:
<a href="<A href="somepage.asp?link=<%=strURL%>">email this page</a>