I need to compare the files in a folder to ones that are entered into a database (filenames list) and update it to include ones that dont have entities.
Whats the best way to accomplish this ? I'v thought of creating an array out of the physical file entities then rolling through the database and deleting the array entities that already exist; that way I end up with an array of filenames that need to be entered into the DB. that way just a thought (I wouldnt even know how to do it) but I want to think it through more thoroughly before starting the code:
I have a static array with 10 elements in it. I am trying to create an update form for a mysql database.
I want to get the info from the database to populate the field of the update form. My select box is populated by the array and I want the value that is stored in the database to be the "selected" element in the select box(= to array element). I hope this is making sense. Code:
I am trying to compare a date in my database to the current date. MySQL statement is:
sqltemp5="select * from users where dateclosed <= '" & date & "'"
What I am trying to accomplish is exclude records where the dateclosed field is older than todays date. Such as if dateclosed = 6/30/2004 then today being 08/25/2004 that record should be excluded.
i am selecting a field from a list .i want to show all the list after searching on the basis of that selected field from database in another list box which is on the same page.
An HTML page that have two dropdown list whit different values:
1. Dropdown list 1(tblname1) =values with different location's. After user has selected one value from the dropdown it should show values from (tblname2) in the dropdown list2.
2. When user select an value from dropdown list2(tblname2) and click on a button "GO" it should show all the value's from the database that been selected in dropdown list1 and 2.
Please someone please help me out with this problem!?
I need to have three list boxes automatically populating each other, (ie when region is selected from the first listbox, it will populate automatically the second one which is the TOWNS and when the town is selected is should populate the third one AREA) all data is in the database in one table.
Is there anyway to store a list of data in an access database.
For example if i have several input text fields for a customer to add descriptions of a particular item, this list should then come together and be stored in one place in the database. This information should then be displayed in a list when retreiving the data from the database.
ive tried to explain what i am trying to achieve, if anyone can advise me on how to do this or for a better way to accomplish this.
I show information from a database in a table format. I will be showing more and more data and would like to show it one page at a time with a next page back page option. Can I do this on a web page and does anyone know where I could look to find out how
I am hoping a mixed ASP- Javascript programmer could help me with this scenario:
I have a list box populated with randomized records (NewID()) from a Broker (Salesperson) sql server table.
Each time the user selects one of the broker items I need to display a Image of the broker in the table cell next to it.
I have found a number of online js scripts that use the image selector route but I am unable to work out to populate the list item from the database AND at the same time utilize the JS...
Are there any coders who come across a solution like this. Here is an example of my ASP code populating the List box: .....
how to show a drop down list with a selected value that is derived from the database? Is this correct? When I do this, it shows "Mastercard" always, even when its "Visa" in the database.
I am creating one web page which contain a drop down list. It use the data from database. Now my problem is when the user select the drop down list value, I want the current selected value update to the database. How to write the code?
Let's say I have a dynamic list/menu, which gets its values from a database table, for example a list of contact people where the value is an ID number and the label is the name. However, if the value the user wants is not in the list I would like to place a hyperlink which will...
(1) open a small window, with an ASP form to allow the user to add a new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about. I don't like the idea of forcing the user to leave the current screen, go to some other form, add the entry they need to the lookup table, then come back; this seems like a logical approach, but just wondering how to make it work.
This seems like a common enough situation; anyone have any code samples or suggestions about how to do this?
How can i list out all the email address into my website from the hotmail caontact list? i am successful log in into the yahoo contact list by using serverxmlhttp and list out all the email address from the page source, but i could not access to hotmail by using the serverxmlhttp. Is any other methos can list out the email address from hotmail contact list?
i want to keep the lower number between my two numbers (nbelem(querystring) is user defined and nbElemTbl is number of elements in the table) in my test nbElemTbl return 6 and nbElem(querystring) return 10 but it will always enter the if statement and my resulting number is alway 10.
SQLQry = "SELECT COUNT(echBassinNo) as nbElemTbl FROM tblEchantillon HAVING echBassinNo = '" & Bassin & "';" set rs = con1.Execute(SQLQry) dim nbElem if cint(Request.QueryString("nbElem")) > cint(rs.fields("nbElemTbl")) then nbElem = rs.fields("nbElemTbl") else nbElem = Request.QueryString("nbElem") end if
I store e-mail addresses in a database that are to be used for notification purposes. When the clients add e-mail addresses I want to check and make sure they have not entered an e-mail addresss in twice. Here is what I've got:
I have two arrays that hold the email addresses from the database and the email addresses from the form. I want to loop through the form's array and check it against the database array. If it finds a match then add it to an error message. If it does not find a match add it to the database. Sounds simple.
Here is the function that does the comparison: Code:
I have created a class registration application with DWMX. The first page shows a listing of all classes (names, date, instructor, etc) dynamically from the database. I would like for the page to only show current and future classes, and need some type of date compare code. Any ideas? Also how does this site make the pop window initiate when a user mouseovers a thread? I know how to do standard popups but haven;t yet figured out dynamic ones.
I need compare the recordset from a database and check if the file exists in a directory. If exists, I show a picture, case not, I dont show....
Sample: The result from a recordset was "hawai.jpg" Then I need to check if the file exists in a directory located in /images/countries/... IF exists I show the image IF NOT I show the message "Sorry, this country doesnt have a picture in the directory."
I have an application that creates online quizzes, each quiz has a results table generated by ASP on MS SQL Sever.
What I want to do is compare the SQL structure / code of the table I am about to create with the SQL structure / code of an existing table (previously created in ASP) to see if they are the same.
So how can I get the SQL structure of a table that already exists in my database into an ASP page?
If record is getting submitted between morning 6 am to night 12 pm the value of sdate should be current date or if the time is between night 12 to morning 6 the value of sdate should be the previous date but this comparison is not working please help me.
if (time()>"06:00:00 AM") and (time()<"07:00:00 AM") then sdate = Year(Date()) & "-" & Month(Date()) & "-" & Day(Date()) Response.Write(sdate) End IF
I am trying to check if the variable size already exists in my shoppingCart array. However even though it does exist, the code below still returns false instead of setting itemp to true.
' 'Check if an item is already in the customers shopping cart ' Dim iLoop, itemp itemp = false For iLoop = 0 to UBound(Cart, 2) If (Cart(6,iLoop)=thesize) then itemp = true end if next
I have this login that i created. On the sign in process i need to make sure that no one has already signed up using that certain email or that unique cnumber.
Ive tried this line: Set objRS = verify.execute("SELECT id FROM logmein WHERE email='" & email & "'") or ("', cnumber= '" & cnumber & "';")
than this: Set objRS = verify.execute("SELECT id FROM logmein WHERE email='" & email & "'", "' & or & '", "' cnumber= '" & cnumber & "';")
Can I have one recordset execute a Select and then have another recordset execute a different Select, and then check if a field from the first recordset is different from the field in the 2nd recordset and if so write out that row on my displaying table?
I have 2 recordsets. One contains all customer info data, the other recordset contains 1 field of customer id's.
How do I create a recordset that contains all customer information (from the 1st recordset)for only the customers in the customer id recordset (2nd recordset)?
I need to check whether the curtime is greater then or equal to 12:00 am or less then or equal to 12:30am.i tried to use timeSerial to check the time but it comes out an error. Wrong number of arguments or invalid property assignment: 'TimeSerial' Code:
if (weekday(curdate) = 1) then if (TimeSerial(curtime) >= "12:00:00 AM" and TimeSerial(curtime) <= "12:30:00 AM") then curdate = date - 1 response.Write "cur_date = " &curdate& "<br>" end if end if
I am doing a project for Insurance Company. Here I have a field where the administrator enters the date he wants to close a particular verification process. I want to compare the closed date with the server date and if the date matches Update the database column as "DeActivated" or else the database column must show "Active".