On the homepage of my site I want to show an overview of the three lastest submitted newsmessages.
How can I do that without loading all the news fields (overload)?
eg. select * tblnews where date1,2&3 closest to now();
Still working on my soccer database, I have a list of 100s of teams and want to give users various ways of accessing the information. One of those methods would be via a drop down box which would have
A-F
G-M
N-T
U-Z
If a user selects a-f how could I write my sql statement so that it pulls out the relevant teams, in alphabetical order, that begin with the letters a-f?
I want to select 5 random records from my database..I tried to suft the net and foundout this sql
SELECT TOP (3) Question, Choice1, Choice2, Choice3, Choice4
FROM Question
But when i tried to execute,i t always gave me the most top 2 records. why?Is this sql statement woring?How can i select 5 random records from the database?
I display work request records from a db table into a .html table dynamically by cycling through the db table until RS.EOF.
To the right of each record displayed I have two checkboxes, "chk_dev_accept", "chk_dev_sendnotif". These are the only editable items on the page.
"chk_dev_accept" is clicked by the developer to assign the work request to his/herself.
"chk_dev_sendnotif" is clicked if the developer wants to notify the customer that the status of the job has changed (optional and automatic - I don't have a problem with this part).
Upon clicking the "Update Record" button, I want the records with the checkboxes clicked to update.
The db record fields that would be updated are: "dev_developer" (The developer that will do the job, read from a cookie) and "dev_proj_status" (changed to 'Assigned'). These two fields should update when the "chk_dev_accept" is clicked and form submitted. I want the developer to check as many records as he/she wishes.
My problem is I'm not sure how to code that <input checkbox....> tag, and then, how to take that checked value to select the appropriate records to update.
Is this do-able with ASP / VBscript?
-- I have a database with user records (name, photo, etc. etc.)
I want to use asp to generate (on the homepage) a series of 4 randomly selected 'user records' from the database -- say just the headshot photo or name from the database.
In addition to the recordset being randomly generated (i.e. our of about 50 records, only records 4, 18, 23 and 26 are displayed) I need to MAKE SURE they are not duplicated (i.e. out of the 50 records, records 4, 18, 23 and 23 -- where the last two are duplicates).
Is there a way I can pull this off and how do I go about it exactly?
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
I have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".
I have the code correct for grouping by location. That code looks like this: Code:
I have written some code which should dynamically build a table which is then populated with questionas and possible answers. The format of the answers will vary ie they may be in the form of a radio button which will be rated from 1-5, checkbox or a selectbox.
The first problem I have is if I do not comment out <select></select> I get an error message saying the page can not be found. when I do take it out I get asp timeout. Code:
does anyone know what I have wrong with this select in my form?
<%
sql = "SELECT * FROM [LTAB_CAProcessArea]"
Set ProcessAreaRS = Server.CreateObject("ADODB.Recordset")
ProcessAreaRS.Open sql, SessionCPRDBConnection, adOpenStatic, adLockOptimistic, adCmdText
%>
<select name="processarea">
<%
Do While Not ProcessAreaRS.EOF
Resonse.Write("<option name='" & ProcessAreaRS("processareaID") & "'>")
Response.Write(ProcessAreaRS("txtProcessArea"))
Response.Write("</option>")
I don't know if this is in the right section. I hope it is.I have an HTML document that uses tables and stuff. I also have a FORM on there with some input boxes, Radio buttons and <select> options.
I have a .asp VB file also that processes the actual form and writes the answered questions to a text file on the server (tab separated)
My problem:
The input boxes and radio buttons work fine. It writes to the text file on the sever end.
My problem is I am not too sure how to go making the answers from the <select> options to also write to the server. They way I have it set up right now, it jsut writes "NULL" on the text file.
I've recently come across using "Select Last" in an sql query. Does anyone have any info or views on using it? Until now I've relied on "Select Max" but Select Last would have distinct advantages when using random autonumbers. I'm also curious about why there is so little info on it - perhaps I'm looking in the wrong places?
View Replies View RelatedI want to display an editable page extract from MS Access table. Now I want to show the value in Select list, extract from another table. Both tables are joinable with the foreign key.
In simplest, I want to extract and display the exact value from a table and show in Select list for edit.
I could not think of any way. I can bring up data and display in Select list but it would display the first value in the list only.
i want to select all ids from table1 where those id's arent in table2
Sounds simple and iam sure could be possible in a single sql statement
I have the following SQL SELECT statement below that doesn't like the TOP 50 parameter. When I remove it, all is good. When I put it back I get "Incorrect syntax near '50'".
Code:
SELECT TOP 50 SSN, LName, FName, License_Certificate, Character_Identifier, CertificateNo, " & _
"tblIndividualInfo.IndividualID, tblLicense.LicenseID FROM tblIndividualInfo " & _
"INNER JOIN (tblLicense INNER JOIN stblLicenseType ON tblLicense.LicenseTypeID = stblLicenseType.ID) ON " & _
tblIndividualInfo.IndividualID = tblLicense.IndividualID " & strWhere & " ORDER BY LName, FName
how to insert multiple items in a select box into a database. For example:
<select multiple name="ComservGroupAge" size="3">
<option value="Children">Children </option>
<option value="Adolescents">Adolescents </option>
<option value="Adults">Adults </option>
<option value="Does Not Matter">Does Not Matter</option>
</select>
I don't want it to go into my db column as one long field.
for this part. can i use
select sum (orderqty) from custorder
i attach a pic file to show wat i wanted to do
a few data will be listed out
i want the total from that particular few records only. not the whole records in database
I know this is an ASP forum but I've also gotten answers to my SQL problems here and I'd appreciate your help very much.
I have these two tables in SQL. Both tables have the same two columns (Description and SiebelName). I want to some how write a script that will look for the descriptions that matches the ones in Table1 with the ones in Table2 and if there are any I would like to take the column in Table2, SName, and update the column in Table1, SiebelName, with that of Table2.
Here's what I attempted to do but it's not working:
--------------------------------
UPDATE tbl_MasterTEST
SET tbl_MasterTEST.SiebelName = Siebel.SName WHERE (SELECT tbl_MasterTEST.ProdDesc, tbl_MasterTEST.SiebelName, Siebel.SDesc, Siebel.SName
FROM tbl_MasterTEST, Siebel
WHERE tbl_MasterTEST.ProdDesc = Siebel.SDesc)
strSQL = "SELECT * FROM mod48 WHERE N_GEN = 5"
oRs.open strSQL,oConn,3
this table has alot of fields. I want it to automatically create alot of Text boxes for each field. But i also need the fields names. The only thing is that the field names in the table are well not very user friendly.
n_gen = General Numer
pa_name = Client Name
pa_surname = Client SurName
So i was wondering is there something i can do. Like a For each that will create alot of tect boxes for each field "with its value in it" and also make it write a description for the lable. Code:
Ik want to select 2 MAX values form one table, but i don't know how that works, and i can't find it anywhere.
This is what i got so far:
sql = "SELECT max(tekstindex), max(volgnummer) FROM menu"
I want to select max(tekstindex) as 'tekst' and max(volgnummer) as 'volg'.
I have a select statement that searches for certain records within a date range entered through a form. what i need to do on another page is count how many records they are and split them into each day within that date range. My original select query is:
Code:
objRSError.Source = "SELECT TOP 100 PERCENT TrapPage, TrapLine, COUNT(TrapID) AS ErrorVol, TrapDescription, TrapASPDescription, TrapCategory FROM dbo.tblErrorTraps WHERE (TrapTime >= CONVERT(DATETIME, '" & objRSError__strFrom & "', 103)) AND (TrapTime <= CONVERT(DATETIME, '" & objRSError__strTo & "', 103))GROUP BY TrapPage, TrapLine, TrapDescription, TrapASPDescription, TrapCategory ORDER BY COUNT(TrapID) DESC"
For instance i do write out such which works.Code:
SELECT TOP 5 * FROM table4 order by id desc
Now how would i select the rest of the records without the first 5.
I have problem, i'm starting using asp and DB
I have query
sSQL = " SELECT count(*) cc FROM ... " &_
" SELECT count(*) ff FROM ... "
Set oRS = oConn.Execute(sSQL)
First count i can get from oRS.("cc")
How to get "ff"?
I have an ASP application.Is it right that I am calling all SELECT's AND DML's through stored procedures and in the ASP page I just call the stored procedure.
I am NOT using COM,i.e.I am not calling the procedures through DLL's but directly through ASP as time does not permit me to add this layer.
tell me is this right and is this a common practise followed i.e.calling stored procedures directly thru ASP without COM.Also,what is the main benifit of using SP than dynamic queries as there are plenty of suggestions dont know what is the conclusion.
how to filter top 10 records from the recordset. In Access I could use "SELECT TOP 10..." but in ASP it doesn't work.
View Replies View RelatedI have a database containing information in different fields one of those fields is a datetime field, i want to select everything from that table where the datetime field is a monday or tuesday etc.
View Replies View Relatedif the user select the EmployeeID in drop down list, and then click the submit button, and it will look up database and show the Employee Name in the text box, this is easy.
But my case is: when the user select the employeeid in drop down list, it willfire the onchange event, and then look up database and show the employee name in the text box. There is no submit button.
I have a form that contains text fields, text areas and select/lists. The form.asp gets sent through: <form method="POST" action="Confirm.asp"> When I receive the completed form it contains submitted info from all of the text fields ie: CompanyName=Request.form("companyName"), but the responses in the 'select' fields are empty.
Do the select (drop down list) fields need to be coded differently than text fields in order for the response to get posted back to me?
how to place 3 Select Box's on screen? The first Select box will have the category heading. The second Select Box will have its sub_Categories. The third Select Box will have that Sub_Category's Products.
View Replies View RelatedI have a Form page with many fields. The name field is a Select button which displays all the names available in a table. On selecting a name, the corresponding Desgination field should be displayed.
View Replies View Relatedmy sql statement outputs this, Am I missing smth ? Code:
SELECT sch_route FROM schedule WHERE sch_date =#8/27/2007# and sch_route ='Night_Owl_East_Orange' AND Trim(Training) = 'No' AND Shift_Interval IN (1,2) AND ((sch_time_start >= '05:12 AM' AND sch_time_end <= '06:45 AM') OR (sch_time_start < '05:12 AM' AND sch_time_end BETWEEN ('05:12 AM' AND '06:45 AM')) OR (sch_time_end > '06:45 AM' AND sch_time_start BETWEEN ('05:12 AM' AND '06:45 AM')) OR (sch_time_start BETWEEN ('05:12 AM' AND '06:45 AM') AND sch_time_end BETWEEN ('05:12 AM' AND '06:45 AM')))
The error
Code:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Between operator without And in query expression 'sch_date =#8/27/2007# and sch_route ='Night_Owl_East_Orange' AND Trim(Training) = 'No' AND Shift_Interval IN (1,2) AND ((sch_time_start >= '05:12 AM' AND sch_time_end <= '06:45 AM') OR (sch_time_start < '05:12 AM' AND sch_time_end BETWEEN ('05:12 AM' AND '.
/den/sch_drivers.asp, line 165
<%@ Language=VBScript %>
<%
Response.Write "<FORM name=form1>"
Response.Write "<select name=""select1"">"
Response.Write "<option value=1>One</option>"
Response.Write "<option value=2>Two</option>"
Response.Write "<option value=3>Three</option>"
Response.Write "</select>"
Response.Write "</FORM>"
%>
I want when select1's value change,run a server-side function.
how do you select all the fields in a table that do not contain any data?? I have tried the below and it wont work??
View Replies View Related