I am trying to change the data type of one of the columns in my SQL table remotely (via ASP scrpit). I understand that ALTER TABLE will allow me to drop and add columns, but I can't find any information on ways to alter the data types.
I want to alter the text displayed in one textbox depending on the value input into another textbox. For example, when entering a customer code into the first box, I want to display the customer name in a second textbox. This will have to be done more than once on a form.
I have a web form that submits data to an email box. I would like it to only send those fields that had input and not the zeros. how to alter my script.
if I add <% Server.ScriptTimeout = 300 %> to a page, does that then alter the default 90 second script timeout for ALL pages (if so, is it for that session or until??) or does it just alter the timeout for THAT individual page?I've been through the IIS docs and I haven't been able to find the definitive answer.
I would like to store a table of alternate URL's it would work like this - in my forums, a user may add a URL (for example www.hyperlink.com). When another user would click on this URL, I would like to call the alternate URL table to see if an entry exists for the domain "hyperlink.com" If so, I would like to alter the hyperlink (on click) to "www.hyperlink.com/123/test.asp" If the URL is not listed in the alternate URL table then I would like it to go to it's original target address.
does this command allow for overwriting (or skipping) the column if it already exists? The reason I'm asking is because the file that I'm reading in will contain the column and the value associated with the column.
However, some files may or may not contain certain columns, thus if it doesn't exist I have to create a new one, or I need to add to it.
does anyone know of a free utility that allows you to alter/create tables through the web for access 2000. I'm talking about the table/db structure, not creating records.
cmdTemp.CommandText = "Select * From users" cmdTemp.CommandType = 1 Set cmdTemp.ActiveConnection = DataConn
rstContacts.Open cmdTemp, , 1, 3
rstContacts.Move CLng(Request("Record"))
i only want this command to display from the users table the details of the user that has the username (from the database) equal to the username of the person who has just logged in from my login form (uname input box) this code at the moment displays the first record, i dont want that.
The following code gets me the day of the month which I use in a query to give me all employees' birthdays for this period. But I have a bug: day variable used in the query must give me todays date(19),it gives me 21 (2 more than I want)
I could really do with some guidance. I am currently hosting my website on a Windows Server, and use ASP pages for accessing MS Access database data and also CDONTS for forms to email.I was just wondering if I were to swap to Linux hosting, how easy or hard ( would it be to change these pages from ASP to PHP with the exact same functionality.
I created a form to allow a visitor to add a new record to a database with the recordset object. Is there any conversion that needs to take place from the form input fields the user gives me to the recordset object? One of my form fields that I have is going to contain a money datatype in my SQL database and so far it's giving a 500 error.
My code in short looks like: strCurrentPrice=Request("currentPrice")
then upon adding to the database the code looks like: rsAddCards("currentPrice")=strCurrentPrice
I am calling a recordset from sql which happens to contain one column that is a datetime in the format: DD/MM/YYYY HH:MM:SS. So when I call that column from the db, it displays in the same format within my page.
However, I would like to be able to display the datetime as part of my recordset, but in a more aesthetically pleasing format (i.e: Sunday 1st May 2000, 7.23PM)
I have tried using the formatdatetime() function along with my rs, but this causes syntax errors. I know this is probably dead simple, but I don't get it!
I keep getting a type mismatch 'cdbl' error on the line: cmd_AlloUpdateM2__incrdecr = cdbl(cmd_AlloUpdateM2__incrdecr)
What's weird is I use this in other sections of my code and it works fine...no error. I've checked and re-checked the code and can't find the why this is happening?
Anyone have any code handy to convert a binary number to decimal and a decimal to binary? I need server-side code to perform these calculations. For example, I'd like to be able to pass 129 to a function and it will return 10000001. Likewise, I'd like to pass 10000001 to a function and get 129. I can do this on paper, just not sure where to start on how to pass these numbers into a function to perform the calculation.
I am in UK using XP with date format set to dd/mm/yy. I am running an asp site from a server in USA, which is returning the date from a database field retrieved as objrec("todate") in US format mm/dd/yy. To rectify this so as not to confuse visitors to the site I am trying to get the date displayed as dd month yy , e.g. 25 January 04 by using the format function format(objrec("todate"), "d-mmmm-yy"). This returns me a VBScript runtime error "Type mismatch: 'format' " The data base field "todate" is stored in short date format, which should be OK shouldnt it?
My database is being converted from Access to MySQL. My question is how do I maintain the database once the switch has taken place? Are there freeware MySQL administration GUI's or something? I'm a little clueless here.
I currently am using a script which submits full state names to a payment processor. However, the payment processor only accepts 2 digit state names. Does anyone have a premade code for asp that converts state names into 2 digit ones. Code:
I'm currently working on a form that, upon submit, generates an RTF file. I've run into a little formatting issue. If you're typing in a text box, much like this one, and hit Enter to go down to a new line, nothing happens in the RTF coding. For me to have a text box Enter/Line translate into my RTF file, I need to replace it with /par . So, I know about the Replace() string function, but how can I make this work with a carriage return
I am basically looking to create / incorporate some form of Auto-PDF generator into a website I am developing, essentially so I can set a webpage which I want it to convert.exactly in the same way that it works when you go to a Webpage then in the Browser you hit Print > and select Adobe PDF printer.This then creates a PDF identical to the webpage you are viewing
I seem to be hitting brick walls with this as I found one option which did this, but this did not support CSS, so exported the page on the fly, but with no formatting whatsoever.I then looked into ASPPDF but this does not allow for this
I have a number of HTML documents that I want to convert to PDF using a server component accessible from ASP.Can anyone tell me which component is the best and cheapest to use? It's a jungle out there
im looking for some code that will convert an inputted amount in sterling to a number of different currencies.i presume i will have a text box and a series of radio buttons that a user will choose for another currency then a button to initiate the code to convert. Could it do the currency symbol also? ie £ > $
I want my site to show prices including VAT. How do I calculate this with vbscript. I also want users to be able to click on a button to convert the price to Euro/dollar/yen - how do I do this and can I use a live conversion rate without having to change it yself (eg get the current rate from a site to use tin the equations)?