WebspoonUK

Try using the SQL Modulus function (%): - UPDATE T SET BSTD = @Qty / @StdB, BEND = @Qty % @StdB FROM dbo.SOMaster_TEMP T WHERE T.PK = @Id Be sure to add a WHERE clause or all records in your table will be overwritten with the same calculation. Happy coding!

Hi mpc123, I think I understand what you're getting at. I would take care of this at the point you insert each data record... Just before you execute your INSERT statement, check for the presence of their last results as follows: - DECLARE @LastId int, @LastScore int, @LastHoles int SET …

[QUOTE=munna_001;1198627]i am writing parameterized insert query uisng asp but get the following error --------------//error Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.line 34 -------------------- i have table in MSSQL column name (item_name nvarchar 20) asp code ---------- itemname=request.form("itemname") cm.commandtext="insert into …

server.mappath will map a virtual path to the actual path on the webserver. E.g. server.mappath("/directory/file.png") this would yield a result like: - "c:\inetpub\wwwroot\webfolder\directory\file.png"

Whatever the Id is of the control you want to set focus to, do the following.... document.getElementById('controlId').focus(); That's it!

Why are you passing a short description through the querystring as opposed to the project id? Why are you storing the project number in the T_People table? Are these people associated with each project in some way? You need to clarify exactly what you are trying to achieve here. Post …

[QUOTE=Trogan;1145625]Hi, I need to create a data-driven log-in form with different permission levels using classic ASP and MS Access. It is intended for a HR Company. What I'm trying to achieve is something like the following: I'd like some help to know which is the best way to achieve the …

Simply convert the number to a string and, presuming it is always 2 digits in length, do the following: - iInteger = txtNumber.Text sString = str(iInteger) sFirst = Left(sString, 1) sSecond = Right(sString, 1)

[QUOTE=singhritesh21;1172042]i want to insert multiple int values selected from dropdown in to a single column seperated by a delimiter(,) along with this values there are some other rows too in which some other values are inserted a table has Booking id which contain values like 1 and roomid which contain …

[QUOTE=Vampdee;1157057]I have a client whose hosting provider dissappeared. He has an old ASP (read: Pre-.net) site and I need to get the site online at a new provider. TO start, I am trying to run it internally to make sure I know how to make it work. I have a …

At the top of my classic asp page, I have a the following code to select the relevant stylesheet depending on which browser is being used: - [CODE]<!--[if IE 6]><link rel="stylesheet" type="text/css" href="../styles/main-ie6.css" /><![endif]--> <!--[if gt IE 6]><link href="../styles/main.css" rel="stylesheet" type="text/css" /> <!--[else]><link href="../styles/main.css" type="text/css" rel="stylesheet" /><![endif]-->[/CODE] The problem is …

Performing a query to achieve your desired resultset above would mean you would have to add min(DayOff), max(DayOff) and group by EID but this would not cater for multiple vacation bookings by the same employee. The best way to achieve this would be to generate a vacation id in another …

Try replacing "MydbFilePath" with the actual hardcoded path of the access DB. If you do response.write MyConn.State straight after your MyConn.Open, this should output a '1' or 'true' so you know you have an open connection Within your <li> tags, try referencing your recordset fields like this: - [CODE]<%=rs.Fields("Country")%>[/CODE] If …

If no location is found then it should automatically default to the first entry in the list. If you simply add the following code before your do..while loop it should do the trick: - [CODE]Response.Write "<option value=''>&nbsp;</option>"[/CODE] Hope this helps

Firstly, it is bad practice to use inline SQL like you have used above. It leaves the page open to SQL Injection attacks. you need to create a function that replaces any single quote with two single quotes before passing through any parameter as follows: - [CODE]function makeSQL(str) str = …

What you need to do is strip out the values from your HTML and insert the data into a DB table. Then use classic ASP to read the data back from the DB. It would be easier to use c# / VB.NET to do this as it'll do most of …

[QUOTE=rajendra.parmar;1160309] There are 6 objects in ASP.net a) Server b) Session c) Application d) ObjectContext e) Response f) Request Regards,[/QUOTE] You mean classic ASP right?

Quick anwser - you can't You have to store any number starting with a '0' as a string as the datatype will remove it if you store it as a numerical data type.

Don't reinstall IIS - that's a last resort. Which version are you using? In IIS 7, ASP scripts are not installed by default so you have to enable the feature yourself for ASP to work. Do you have any other ASP sites running correctly under the same IIS?