Thanks for the reply. I just did this in Access with a Pivot Table which will work for what I need... but I'd still like to know what the query would look like and try to do this in ASP. It's just something that I think would be nice to know how to do. I'll try to mess around with it...
Hello everyone,
I am writing an ASP script to display data from our sales reps in a tabular format with sums for each item (Style) per sales rep. I've searched all over here and google'd everything... UNIONS, JOINS, PIVOTS with no luck.
This is the table:
Style Color SalesRep Units [CustNumb...
I've tried looking up info and can't really seem to get a grasp on how XML works... can someone show me how to parse this into a table?
-----------------------------
<character name="Alexianna Summerbreeze" id="322413" laston="2_Weeks">
<race>Saracen</race>...
Hello everyone. I'm using SQL 7.0 on NT4. I made a forum that uses SELECT COUNT(*) to count the number of replies and display them. Unfortunately, I think that's slowing down the system. I made a column called "Replies" and now can't seem to get a script to update the Replies...
Hi everyone,
I keep getting this error and can't figure out what it is. I'm running WinNT SP6a with IIS 4.0. Anyone know how to solve this?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed
Thanks in...
Hello everyone. We're running WinNT 4.0 SP6a and IIS 4.0 with SSL. Before SSL, our site was running geat. Now that we installed SSL, it's realy, really, really slow. I just realized that I can access any part of the site with https and not just the pages I specified. I checked the entire...
Hi everyone! Please help!! The paging through records is fine, but it keeps counting through all the pages!! I want to show only 10 pages at a time. I thought i just had to change the iPageCount to 10, but that didn't work =(
If iPageCurrent > 1 Then
Response.Write " <TD><A...
This is great, but one little problem. I don't want the linefeed to break the line. Basically, the textarea is smaller than the display area, which is just a cell in a table with a size of 100% width, so it ends up getting cut off. Is VbCrLf for just CRs or does it include things like...
Hi, I'm having trouble with this. I'm trying to replace carrige returns with <BR> and trying to ignore automatic linebreaks from the textarea. The following code is what was already done by someone before I started working here.
<%=replace(rs("content"),chr(13) & chr(10), vbCrLf)%>...
Ok . . . I've been trying to fix this for too long. It works great with just one item like that, but not with 2. I need one for State and Country. I can't seem to get it to work with Country. These are the changes I made for Country:
<select onChange="flip('reasonBlock',this);">...
...the problem is (in red):
<% @LANGUAGE = "VBScript" %>
<% Response.Buffer = True %>
<HTML>
<HEAD>
</HEAD>
<BODY>
<%
sql="select * from logins"
Dim RSlogin
set RSlogin=server.createobject("adodb.recordset")
RSlogin.open sql, "dsn=mydb1"
if not RSlogin...
...objConn.Open strConnection
Set LoginRS = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * FROM tbl WHERE (BillID = '" & NewID & "')"
LoginRS.Open SQL, objConn, 1
If Trim(LoginRS("Agree")) = 1 Then
put in the contents of newacct3.asp
Else...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.