I am doing a scheduling system. The concept i have but i am weak in my programming, therefore i hope that u all can help me on this.
i have a capacity (uph x shift x 7.17) and orderperday (total orderqty per month / total shift per month)
the thing that i am not sure in is, i want to do a comparison it is becoz there is a capacity limit per day. i cannot afford 2 produce overlimit. so if the orderperday > capacity then orderperday - capacity = balance. balance will be bring forward to the next day to produce. then the comparison will be done again. i am not certain on how to do the looping in this context.
i am trying to get a piece of code that will check a value and then act accordinly - the usual thing with a For loop enclosing IF THEN ELSE loops - heres what i have Code:
FOR removecounter = 1 to 15 IF removecounter = Session("newoptions") THEN response.write "THEY ARE THE SAME - NOTHING TO CHANGE<br />" ELSE IF removecounter < Session("newoptions") THEN response.write " NOTHING TO CHANGE <br />" ELSE ' the only other thing it can be is > Session("newoptions") response.write "BLANKING THE UNUSED<br /> " END IF END IF NEXT
the Session("newoptions") is a value between 1 and 15 - i simply dont understand why this thing doesnt work
I have a recordset that I loop through all of the data within a table, within the same loop, I am trying to add another loops that pulls information from the first recordset to base the second recordset off of: Code:
I am creating a website that is going to ask the user to enter a date! then from an access database get all records where a date field is greater then the date entered! Sounds simple, I do it in vb all the time!
here is my sql line: Select * From Participants WHERE DateJoined > 01/14/07 ORDER BY TournamentID
it updates fine with the date the user has entered! I know in vb I need to put ## around the date I am comparing! I tried that, I tried %%. still I am getting all records from the database
I need to compare an IP address to a database that contains ranges for each byte in a potentially "valid" IP.
Columns in the msSQL db are IP1, IP2, IP3 and IP4.
The problem is that one entry in the database may have a range. If I were to query all four columns and concatenate the data, I may get something like this:
12.35.124.12-89
So if a user sends me 4 variables (1 for each byte in IPv4) over a form, how I would I begin to compare this data?
I have problem regarding the Dates. I am storing Expiry date of the item in DB as varchar since I want date to display in the format MM/DD/YYYY HH:MM.
From user I am taking expiry date in dd/mm/yy hh/mm format and then using toLocaleString() function to convert it into string to store in Database. This function stores date in the format
Sunday, May 1, 2005 10:00:00 AM.
Now at the time of displaying items I am comparing this date to current date. I want to display items which has Expiry Date greater than today�s date. But it is not giving proper result. It is showing items whose expiry date is previous than today�s date. So not showing the desired result.
Just wanna ask if any1 noes the method to compare between current date(today) with other date and state out the difference of days in between? and also for current date(today) is it date()?
My name is Abhishek. I am writing a code in ASP which wants to access all records from SQL Server database where date lies between 11/24/2004 and 12/20/2004.DateVal is a field in custdate table.Can u reply me ASAP i.e. within 2 hours.
I am writing a script that allows a user to edit one record and its fields in a MSSQL database. For the time being I don't mess with the data, I just display what the script thinks should be updated.
Output is below.
Field name => Original Value = New Value submitted by user
If the 2 variables after comparsion return true, then the statement: This file had been inserted already will be displayed! but currently, there is nothing shown when i execute
I'm comparing a date held in a string with a date held in an access database using an SQL query. However despite tests in which the string and the date held in the database are exactly the same, no matches are found.
Here is my SQL query:
SELECT id, TimesheetDate FROM Timesheets WHERE TimesheetDate=VarDate
The format of the date in the database and the format of the string are exactly the same.
I understand this is because the VarDate variable is a string and not comparable so how do translate the string into a date format the database can make a comparison with? I've tried using CDate() with no luck.
I'm looping through database results where I have a date time field in the format: 9/2/2007 6:28:53 AM. What I'm trying to do is flag entries that are within the next 12 and 24 hours with a different color. I'm doing this currently with a counter field on another project like this:
PMCOLOR = "#000000" If cLng(rs("target_current_value")) > cLng(rs("target_value"))- 2800 Then PMCOLOR = "#FF0000" End If If cLng(rs("target_current_value")) > cLng(rs("target_value"))- 1400 Then PMCOLOR = "#FF9900" End If
This turns the line red if the current value is within 1400 of target and orange if its within 2800 of target. I want to do exactly the same thing with the date/time field flagging entries red if they are within 12 hours of the current time/date and flagging them orange if they are within 24 hours of current date/time.
I'm not sure how to break down the time and date and compare them to the current time and date, though. Its easy with integers.
I had a script set up to create a redirect until a certain date, and I left the script in there after that date thinking it would just be dormant until I changed the date parameters. To my surprise, it started redirecting again. I must not be clear on how dates work. Here is the very simple code:
<% if date < "8/20/2005" then response.redirect(url) end if %>
I want my website to support multi-lingua, so I add Codepage="65001" in my english website. However, after adding that, all the string comparison failed (login page, catcha). I thought I only need to add codepage, then my website will become multi-lingua site Did I miss something?
I have a site where I need to compare the current date with the clients wedding date. (ie: 3/09/2005 with a wedding date like 6/15/2006) Here is what I'm using now.
CIExpires = DateDiff("d",CurrentDate,WeddingDate)
It will give me either a positive or negative number. I then just use this to either show or hide a link.
If CIExpires <= 0 Then
'don't show link
Else
'show link
end If
What is the best way to do this? The one above just doesn't work.
I am doing a date comparising. Is it possible to compare a selected date with current date which call from date function in VBScript. If can please show me the coding or reference or source online. Or you all have any idea on it?
I am back with another question. I need to have the user input two dates for a date range--thats easy! But now I would like to pull all the files up in a directory that are within that date range. I don't know how to do a comparison on dates.
I already have a working script with a loop pulling up all the files in a directory based on one date entered and listing them ---now I want to make it pull up all the files within this date range---just need to know you can do a date comparison in asp.
I am trying to pick up records from a date range without much luck. For my example below I am trying to pick up all records made in the last month. However none are being found (my code is tried and tested for all records). My database is in Access format. Field "datetime1" is of Date/Time data type getting the default value by using now()
The relevant part of my code is as follows. Can anyone see what I'm doing wrong?
I have looked all over the net and even down the back of the sofa but I've been unable to find any scripts that allow me to add price comparison functionality to my shopping cart. where a script might be or even offer some pointers as to how I might go about doing this.
First off, this is not the standard problem that can be solved by using:
SELECT * FROM table WHERE string LIKE '%abcd%'
It's actually sort of the opposite of that. I'm looking for a query that can take a string variable and will return only rows where the complete string in the relevant column is a string of the variable passed to the query. So for instance, if the variable passed was 'abcd' then...
rows containing only these strings in the relevant column would be returned:
'abcd'
rows containing these strings in the relevant column would NOT be returned: 'abcdefg' 'abcdxyz' 'abcd1234' 'abcde' 'af' 'hijk'
sql3 = "SELECT DISTINCT State FROM Property Where TypeID = '" & srch_cat & "'"
In the database, is a field called expiredDate I am trying to show only records whose expiredDates are greater than todays date, but I am messing up somewhere. The values in the fields are as this: 3/7/03 (or something like that...no time is added to it)
select case code case "01" ups_desc = "OPTION1." case "02" ups_desc = "OPTION2." case "03" ups_desc = "OPTION3" case "07" ups_desc = "OPTION4" case "08" ups_desc = "OPTION5 " case "11" ups_desc = "OPTION6" case "12" ups_desc = "OPTION7" end select
I then have table called "users" which has the following id UserID Code
now the trick
I want to loop through the recordset of the user tables and populate a drop down where the code from the case and the user table are the same.
Something like
do while rs("code") = code <option> This then is populated based upon the loop(I have this code)</option> loop
i have 2 tables (A & B) with date records now i loop table A and then table B, the output will be table A in the front and table B in the back.how can i make the output show by date in both tables altogether? do i need to combine tables before but the number of records is over 100K which may spend a lot of processing power?
on my classifieds site i would like to create a simple ads system. i currently have the ads site made but need some advice.
on my classifieds site i would like to display the ads down the left hand side.
however i dont want to over display ads.
if there is not many items listed i only want a small amount of adverts shown on the left hand side. however if there is lots listed i would like quite a few adverts listed.
otherwise i would have a big list of adverts and only a small number of items listed making a big blank space on my page.
i am guessing this would have to be a loop or something.
the code i am using to show the text links is <%=adurl%>
I am using a for loop in one of my asp page. Could someone let me know if I can do the for loop as follow:
[code]<% for i = 1 to 5 %> my html code my html code my html code <% Next i %> instead of [code]<% for i = 1 to 5 Response.Write "<input name = 'id'"&i&" type='text' value = "&id& ">" Next i %>
im writing some script to add records to my db. but if a value thats about to be added exists, then dont add that record.for example: if i want to add 7 records to my db with the values 1 - 7, but the db already has 3, 5 and 7, then it should only add 4 new records (1, 2, 4 and 6).
i have a record returning all records form my db, and an array with the values i want to add. i want to loop through my recordset of all existing entries, then for each loop, start another loop to see if the value exists, and if it doesnt , then add a new record.
How to use the for loop or do while loop to create the age range from 10 -100 to let the user to select from the form object - list/menu by using asp? The coding below is just a concept. For example
Response.Write("<select name=""select"">")
for (a=0; a<101; a++) ( Response.Write("<option value=""" & age & """>" & age & "</option>") )