Discount Web Design Blog

Hello,
I have a website in ASP with MSSQL, which I want to move to another server.
I have moved the files but I dont know how to move the database.
Can anyone help. Thanks.

Hi all,
I’m trying to run a script that checks the data in a database and looks for hyperlinks. I can find the hyperlinks and open them within the existing window but for the life of me I cannot get it to target a new window to open the document in.
Can anyone please explain? Here [...]

I have a Classic ASP Application the Queries an SQL DB (actually a Read-Only Table View to a FoxPro DB through a Linked Server in SQL). Anyway, it pulls a bunch of records; and then does some computational summary of the data that is pulled. The Queried information changes very frequently. I [...]

Hi,
I’m using ASP to select a bunch of records from a table in my MS Access table.
I’m wanting to display them in ascending order by date added.
I’m currently using ORDER BY date_start ASC
I’m storing the date with the date field type using #23-02-2010# hash symbols on either side and in the dd-mm-yyyy format
How do I [...]

Part I
Well, since my How to use CDONTS peice has been so popular, I thought I would introduce another component that you all might find handy. But like the CDONTS one, I don’t devel too deep into it. Basically I tackle one aspect, but if you want more info, don’t hesitate to ask. To the [...]

Hello
I got a detail page where the form value are selected and users are allowed to edit in the form inputs and even for new case same form is being used.
But i got the problem on validation of username after submitting.
If username already exists in database then error message is displayed which is good for [...]

Hi All,
I’m hoping for a little help please! I have a client who asked me to take over a couple of existing sites for them the bulk of which is built directly as html so is nice and straight forward. However there are couple of forms on each site using asp which i have no [...]

Hi,
<%
a=17.01
b=16.50
response.write a-b & "<br>"
%>
The code above should return 0.51
However it returns 0.510000000000002
Why is this?
Thanks
Simon

hi all i successfully connected some sql server 2000 on my local machine and it’s working great with my default windows user
so when i upload it to the server
how can i configer it with the server ??

Hi
I have a recordset that i would like the enduser using the program can order the results displayed on screen themselves i.e. in excel you can order the data by asc or desc by clicking on the relevant column.
I know in my query that is fetching the data, i can use the order by clause [...]