I have a table whose field names are very wierd and difficult to udnerstand. And when users see those field names and text boxes to enter value... they become 8(
as my input form is displaying like this
for all fields in the table
RS.Fields(index).Name : <Input type=text>
next
I added description to each column in database(SQL Server) so that i can understand... is there any way so that i can show that description of column to the users. Code:
I set an Description to an Table in MsAccess Database, I Open the recordset of the table in the database in my asp file, now, how do I retrive the Description I set to that Table from asp?
If you were to Google "Sears," (or other big names), Sears' website pulls up first. Beneath the link is a description that Sears includes in the "description" META tag. That I understand and know how to do.
However, after the description are four other links: Baby, Clothing, For the Home, and Computers & Electronics. How would I modify HTML/ASP so that sub-descriptions to pull up in a search engine for my sites?
Does anyone know how (using ASP & VBScript) how to extract the description from a webpage. I mean the meta description contained in the HTML (eg <meta name="description" content="description of website">).
How to keep the spaces before the description line in the following code? Right now, it displays like "Net Income", but I like to have spaces before the words like " Net Income". The database value is " Net Income".
I saw most of the image upload posted here but can't find one that can upload an image to a folder and make a link in the database and at the same time include description, name, etc. to the database on the same row.
I created this form to include the picture, name, price and description to be upload into a database. I know i need another script to perform the upload, so i name it upload.asp, so what shd i write in the script? Code:
Ok the kid who put together my shopping cart did a pretty good job. Each item is housed in a SQl db table, however I one problem..
The description field can only carry a max of 1024 char and is a NVARCHAR.
Should I...
A. just add three more fields to the db of the same type and add 3 more text boxes to my eidt product page and pull all 3 out when i build the page?
B. Change the current DB type to something other than NVARCHAR?
C. Find some other way to store my descriptions that I have not yet even realized could be done?
anyone have any ideas... Im no guru, but I know enough to get myself in trouble. heehee 1024 is not even close to enough room on some products. Some of them I need about triple that space easy.
I have a csv file that I'd like to be able to add a column to. Specifically, I want to take the first 6 chars of the filename and add it to each row as a new column. e.g.
Ok let me explain what I am trying to do as easily as I can. I have a table in my access database that I am connecting to. I select a specific id number using my SQL statement. Now what I am trying to do is scroll through that records row and get the column name of that column along with the value of that cell. I hope that isn't to confusing. Now I'm not sure whether this would be done using ASP or done in my SQL statement. Code:
How do you get the description of fields in an Access database? I really need this and can't find it anywhere.... It would also help if someone showed me how to get the datatype and other info (like if it's a Yes/no or True/False field). What is the resource/doc for this so I know where to look before asking from now on?
Ok i'm self taught with regards to ASP so not great etc, so sorry if this is a really basic question..
On the last line here i'm trying to some how get it to call the last ID entry...
ImageID = Request("ID") If (Len(ImageID) = 0) then ImageID = "1" If Not IsNumeric(ImageID) Then ImageID = "1" If ImageID = "0" then ImageID = "1" If ImageID>3 then ImageID = max(Len(ImageID))
This is basically for some max min links for a online comic here's what it links to
I need to set up an HTML table or the like, with 4 columns. Each column needs to have a header with a FRIDAY (dd/mm/yy) date. i.e. this weeks Fridays date is 16th Feb, the following is 23rd Feb etc. So, I need column 1 to be headed 16th Feb, col 2 to show 23rd Feb etc. As this week passes, the dates need to move up 1 week, so that next week, col 1 will display 23rd Feb and so on. These headers need to change according to the date. Please can you advise how I best achieve this ?
we have a requirement to freeze the column and row column heading... so that when the user scrolls to the right the first two columns ( I refer them as "row headings") will stay and the remaining columns scroll left and when the user scrolls to the bottom the first row stays ("column headings")and the remaining rows will scroll up.. This can be easily accomplished in EXCEL by freezing the itersecting cell... How can the same be accomplished using HTML tables /ASP code.... Is there any Active X control available that can be used to accomplish the same?Our technical env is ASP and Oracle DB
I have a SQL query that produces a table which displays account numbers and the amount owed on those accounts.
the page that displays that table is written with ASP. Does anyone know how can I highlight the rows in the table where account numbers have more than 7500 dollars in amount owed? Code:
im reading from multiple databases, and one restraint is that i must know the amount of columns and the names of the columns before i can display info from the database.my question: can i somehow GRAB or READ this information from each database and then just adapt my Display accordingly
I have an asp page which the user enters a time(e.g. 12:21). I need to insert this time into a SQL Server DB, which has a smalldatetime column.
I have tried everything I can think of (such as CDate, TimeValue, FormatDateTime etc) to convert the time string, into a valid time. However, the insert always try to insert a datetime datatype (e.g. 12/12/1899 12:21:00).
I am trying to process the insert through ado, eg:
Is there a way to have a piece of repeating information display in multiple columns like a phone book? I need to display a list of contract numbers which will link to the actual contract.
There is no other information to display and it would be better if I could display 3 or 4 columns on the page like a phone book. Hope that makes sense. I am using Dreamweaver and it's and Access db if that helps.
I've searched high and low in this forum for an answer to this one. maybe someone knows where it's at.
Let's say I have a page that is displaying fields from the database. There is a column of numbers, that at the bottom of the page I would like it to display the total of those numbers displayed. Is there an easy way to make this happen?
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.
i want to extract out certain column from my table . can i do it using the checkbox . eg. when i got ten check box then when i select 4 of it . the selected 4 column will appear in my next page . can i do it this way ? or is there any other easier way ?
