how to selct from a database all records that have the same Company Name and have that information automatically change depending on who is logged in, based on there Company Name.If Acme company has 5 members signed up I want any of those users that login be able to view all other users from that company.Is there a way of writing the script to do this?
View RepliesI've had a look around for a few hours for a solution to this problem but can't really find one so maybe someone can help or point me in the right direction.I have a database with fields like Name Date Project Hours worked etc and i want to make an online form where the user can type in their name and the date and it will show the record that contains there name and that date.
View Replies View Relatedi need to go through a list of items and check to see if items on list 1 are on list 2 and vise-versa. so im going to look at item 1 on list 1, and go through all the items on list 2. if i find a match, ill update the record on list 1, if i dont find a match ill update the record on list 2.
im going to need a nested loop. in c++ i know how i could do this, but im not sure as how to do it in vbs/asp. can you do for each "record" in "myrecordset"? or do i have to get the number of records in the table and run the loop that many times? which would be eaister?
I have ASP1 page with few input text fields.All the field have similar name ie testf1, but different id.
eg
<form name="test1">
<input name="testf" id="TF1" type="text" >
<input name="testf" id="TF2" type="text" >
</form>
When I summit this form, It called another asp2.On this asp2, I would like to retrived all the fields values from ASP1, using id.Is there any way I can retreive fields values using id.
I have 2 fields in my table
Warning1
Warning2
They are varchar type and hold date data
So i want to check if todays date is between warning1 and warning 2
strdate=getdate()
strwarn1=rs("Warning1")
strwarn2=rs("Warning2")
str="select * from records where strdate between ('" & strwarn1 & ", " & strwarn2 & "')"
I am retreiving the records and placing them in the original form with stuff going in its own text boxes and all. i have a few checkboxes and when i retreive the records,i want to even see the checks in the checkboxes.
so that the user can see all the info abt that record and if they want to uncheck any. they can do so. So how do i retreive those checks in the checkboxes?
I on my site i have a form that users fill in, once they have filled it in, they are then redirected to a preview page. All this is fine.
Then users get redirected to a secure third party that takes all the customers credit card details and checks them all.
If they are all authorised then it will the go back to my page to confirm that everything is ok and that their information has now been added.
What the problem is that i can not carry the information through the secure servers pages and what I need to do is basically get the user to fill out the form have it inserted to the database, then they pay for it, If all ok i want to be able to insert a "confirmed" into the payment field for the advert that they have placed or if it fails for it to say "awaiting payment" in the payment field and a message on the screen to tell them to contact sales team.
basically i have given each customer, in tbl_user, that goes through the first page an "autonumber" (userID) and then each window has this same userID for each window that user selected. so i can then see the relationship between what user wants what windows.
My trouble is that im having difficulty creating a system where the correct userID is entered with the window Code:
I have 3 tables, product, industry and plist. product has productID and product, industry has industryID and industry, plist has productID foreign key with productID on product table and industryID foreign key with industryID on industry table.
In the plist table I am storing the productID and the industryID's that relate to that productID..
industryID productID
1 4
1 7
1 9
1 10
etc.
What I want in my ASP page is to return the actual products that each industry serves. So for the above example my script should return the products in the product table that relate to the productID's 4, 7, 9, 10, when I search it by industryID 1. I hope this is making sense. Code:
I have a form which only authenticated users can access (Basic Auth against an ADS domain). Currently, I use Request.ServerVariables("LOGON_USER") to display the login name of the user. This information is both displayed and submitted as apart of the form in a hidden field.
What I would like to do is to poupulate the form with user details from an LDAP directory (ADS at this stage, but quite possibly changing to CA eTrust) such as Name, Email Address, and contact numbers. Does anyone know of any resources which might outline how to acheive this, preferably with any code samples to acheive this?
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:
when i update a database from an asp page i get the error:
**filename**
Source: Microsoft JET Database Engine
Error: 80004005
Description: Record is too large.
Line: 435 Column: 0
Code: Connection.Execute(sSQL)
is there a limit to the maximum updatable fields that anyone knows? the fields are text but theres 62 to update, it seems to top out at about 18 fields?
I'm making a leaderbord in golf and i only want the top 3 leaders out from the database. My code is as follows.
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={MySql}; Server=myserver; uid=username; pwd=password; database=database; option=3; port=3306;"
Set rs = Conn.Execute ("Select TOP 3 FROM leaderboard ORDER BY points desc")
WHILE NOT rs.eof
%>
I'm getting this error message.
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '3 FROM rangliste ORDER BY Oakies desc' at line 1
I have a javascript function that sends table data to excel. One of the tables is 238 rows, not big but it doesn't send, i know the code works because i tested other scenerio's and they all went to excel. Does anybody know how many records you can bring to excel?
View Replies View Relatedtrying to make a DDL with records with only checkbox's that are checked in database
View Replies View RelatedI have a few fields in a table: ScoreA , ScoreB, ScoreC , TotalScore
how to i sum up the number value in the Score A ,B and C
and save too TotalScore field ?
Is it something like below
do until rs.EOF
for each x in rs.fields
totalScore = totalScore + x.value
end if
next
rs.MoveNext
loop
or maybe use this
SqlQuery = "SELECT SUM(ScoreA,ScoreB,ScoreC) AS TotalScore FROM Scores WHERE Member_ID = " & memberid & " "
and then do a sql update ?
How can I get the last two records of a RS,I use this code to get the LAST record,but I want the LAST TWO records.
Code:
Private Sub GetLatestRecord()
Dim SQL
SQL = "SELECT * FROM tblHouses WHERE DateAdded = (SELECT Max(DateAdded) FROM tblHouses)"
SET objRS = objConn.Execute(SQL)
End Sub
Im having some trouble displaying top 10 records.here is my sql in my asp
strSQL1 = "SELECT Top 10 * FROM tblFlashinfo ORDER BY Vote_Score DESC "
it orders them correctly but displays all of them not just the top 10 . How can i fix this?also i have another question, i need to make sure a user can only submit a form with the same hidden field value once in a 24 hour period. Is this possible and if so how may i do this? both problems can be seen in this little system im making.
i want to have a table like this
id
Gift_Id
id will be autonumber and gift_id will be alpha numeric field . i want to generate this table with a query. i want to have the alpha numeric field to be 12 digits long. so i want to have like 50,000 records for it. how can i do it.
is there a command so i can read the lastest record/column added to a specific table?
i'm trying to read IDKEY from table A & copy it into table B.
Code:
Surname = ChkString(Request.Form("Surname"))
SQL_CUSTID = "SELECT * FROM cust WHERE CUSTID= 'Surname'"
CUSTID = SQL_CUSTID
sql_insert2 = "INSERT INTO buy (CUSTID) " &_
"values(''"&CUSTID&"')"
objConn.Execute sql_insert2
I'm writing a news script in asp with an access database. I want to show the last/latest 3 records, and have all the rest of them ordered into pages of 3 in an archive. How can I do this please? 'cause I know how to show the first 3 records but I can't work out how to show only the last 3.
View Replies View Related- i have a db with a "category" field
- there are 5 categories: sports, computers, furniture, collectors, others
i want to get the total number of records for each category.
how do i start doing this?
username2 = Request.Cookies("wo_username")
sql = "SELECT * FROM customer WHERE customer.username = " & username2
is there anything wrong with this ?
i have a working members registration script where members register and it emails confirmation of their registration details to the email address they enter. what i would then like it to do is add them to the users database. I have the code but it chucks up this error when it tries to add the user:
Microsoft OLE DB Provider for ODBC Drivers- Error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/members/addmember.asp, line 11
Any ideas? Code:
How do i Count Records with "the same values"?
Name, Age, Sex
John, 20, M
Barry, 24, M
Eve, 19, F
How do i Count the Males and Females?
Like "There is currently 2 M and 1 F registered"
To count them all I would just use rsTable.RecordCount, but dont know how to Count them the way i want them to.
Any build in function that can calculate number of records in a table?
View Replies View Relatedi have a table from i want the last 25 records according to the field s_id(primary key).
so i have this query to begin with:
strSQL = "SELECT * FROM tblData ORDER BY S_ID ASC"
what should i do to achieve that?? PS: database is SQL Server 2000 and the field s_id is number.
Course_Info and Students. Course_Info holds all the information for each course that a student can sign up for. The Students table holds all of the student’s information. The field that ties the two tables together is Course_Name.
I have an admin page that I would like to display the total number of students enrolled for each class. How can I count the records in the Students table, and then display the total number of students that are enrolled in each individual classes?
Does anyone know if it's possible to use the records stored in an Access 2002 database to log users into an ASP.net page? I'm trying to code it in vb.net but im not sure how it could be done. Basically I think I need 2 text boxes on the ASP page where the user can enter their name and password.
I then somehow need to retrieve the name and password from fields in the database (using ADO.net i think) and compare them with those entered by the user. If they match then I want to load another page, and if not then I want to display a message saying login details are incorrect.
Any help on this subject would be much appreciated- the fields i have at the moment are called 'User' and 'Password' in a table called PERSON.
Is there another way to count the records of an access database that have a specific field other than using a SELECT statement and a recordset to loop through the records?
View Replies View Relatedcan we print asp records which are retrieved from data base with a print button
View Replies View Related