recordset.addNew() with postgres
hi guys,
i am using postgres 8.2 and try to add some records to a table with
ADODO ... unfortunately i end up with an error when calling the
addNew() method. it says that the recordset does not support
updating...
i do open the connection the following
set RS = server.createObject("scripting.dictionary")
RS.open "usr", cn, 1, 3, 2
RS.addNew()
RS.update()
RS.close()
set RS = nothing
cn is the connection established with OLEDB ... connection works fine
(i can execute SQL-statements, etc) but the addnew does not work ...
the same works fine on MSSQL
does anyone have experience in this? Tag: f Tag: 329892
Run SQL on form button and output result on page
Hi,
I have an asp page with a form.
A user enters a serial number in a text box.
I want to add a button next to the text box such as 'Check Serial' to
run some SQL in the background to see if that serial exists in the
table, and then output 'Serial found' or 'Serial Not Found' next to
the text box, so the user can decide whether to continue with the
form.
Appreciate your help.
Thanks
David Tag: f Tag: 329890
CHECK IF USER ALREADY LOGGED IN
Hi all,
below is an insert statement on an asp page that stores the date and time
that a driver logged on, what I need is to check that they are now already
logged on fields are
SQL Server 2000
ID int
DRIVER_NO int
ON_DATE datetime
OFF_DATE datetime
ON_NOW nvarchar
SESSION_ID int
The ON_NOW column reads on or off depending whether the driver logged out or
not, if they havent we need to close the previous logon session and mark it
with 'off' and enter a date time into OFF_DATE column.
sql = "INSERT INTO logon (DRIVER_NO, ON_NOW, SESSION_ID" & _
") VALUES (" & _
"'" & username & "', 'on', '" & Session.SessionID & "')"
racking my brains with this one for days any help would be appreciated.
--
Simon Gare
The Gare Group Limited
website: www.thegaregroup.co.uk
website: www.privatehiresolutions.co.uk Tag: f Tag: 329882
adding e-mail system (for web based tracking system)
Hi,
I am currently developing a final year project which is a web based
tracking system tracking exam questions. I am using IIS as the
server, MS access for the database, and ASP with VBScript for the
scripting side of things.
One of the things I want to do would be to e-mail a user/moderator
whenever a exam question is edited/completed/updated. does anyone have
any previous expierence in this? i don't even know where to start. Tag: f Tag: 329869
Adding new record using previous record information... help!!
I need some help. I have an .asp page that interfaces with an Access
table (wjs_SuperInput). The .asp page looks to the table and pulls a
recordset based on a job number, 12345, and a weekending date, mm/dd/
yyyy. If there is no record for that job number with that particular
weekending date a record is created, and the page refreshes, with form
fields to allow the user to edit the record and then update it.
Fields in the table are:
jobNumber - number
weekEndingDate - date
currentHoursA - text
currentHoursB - text
reportRequired_01 - yes/no
reportRequired_01b - yes/no
The weekending date changes every Friday. Currently, today, the
weekending date would be for 4/5/2007, tomorrow morning the weekending
date moves to 4/12/2007. If a user goes brings up the page looking
for job number 12222 today the code looks to see if there is record
for that job with that weekending date. If no, record exists one is
created and then the user can edit that record. Problem is, tomorrow
is a new weekending date and there will be no record for job 12222,
which is ok, but I need to grab the yes/no data from weekending
4/5/2007 so they carry to the new record. Make sense?? Thanks for
any help in advance... Tag: f Tag: 329864
session variables not working on one machine
Hi. I have a website written in asp that uses session variables. On
one workstation the session variable always comes back as an empty
string, like it doesn't exist. What could cause this? Is there a
browser setting or some type of security that can control whether
session variables are created?
Thanks. Tag: f Tag: 329862
COPY field values?? Need Ideas!
I have an issue and I am not sure what the best resolution would be.
Currently I have an .asp page that looks for a record in an Access
table (tbl_WJS_Input) where the week ending date is mm/dd/yyyy and
JobNumber is 12345. If the 12345 job number doesn't exist with that
particular week ending date the record is created. The page then
displays the form fields to allow the user to update the fields in the
table.
Fields in the table are as follows:
jobNumber - integer
weekEndingDate - date
currentHoursA - text
currentHoursB - text
reportRequired1 - yes/no
reportRequired1b - yes/no
reportSubmitted1 - yes/no
reportSubmitted1b - yes/no
This week ending date changes every Friday. Currently, if a user
brings up the .asp page the week ending date is 4/5/2007, tomorrow
(Friday) the week ending date will change to 4/12/2007. So, tomorrow
when the user brings up the .asp page it will want to create the new
record with the 4/12/2007 weekending date. I need to grab the yes/no
settings of the week ending 4/5/2007 recordset. I am not sure how to
go about doing that?
Thanks Tag: f Tag: 329860
concatenate Access memo fields?
I have an ASP that displays two MS Access memo fields in separate table
cells just fine. However when I concatenate them with SQL as in "select fld1
& fld2 as temp...." to display them in one cell only part of the first field
is displayed in the table. What is causing this?
thanks
LJB Tag: f Tag: 329859
Accessing MS Access problem.
Hi,
I'm doing a web based tracking system for exam questions. Using ASP
with VBScript to link the database. I have the main log in screen
working but when i enter the log in details i get this error:
- Error Type
Provider (0x80004005)
Unspecified error
/ets/functions.asp, line 20
my functions.asp file looks like below. I am a total beginner with ASP
and VBScript by the way, any help would be awesome. cheers
<!-- #INCLUDE FILE="adovbs.inc" -->
<%
'---------------------------------------------------------------------------
' Global Variables
'---------------------------------------------------------------------------
Dim cnnProject, cnnProjectUpdate
'---------------------------------------------------------------------------
' Open Database
'---------------------------------------------------------------------------
Function OpenDatabase()
Set cnnProject = Server.CreateObject("ADODB.Connection")
cnnProject.ConnectionTimeout = 5
cnnProject.CommandTimeout = 30
cnnProject.Open DB_PROJECTS_CONN_STRING
'Server.CreateObject("ADODB.Connection").Open
"DBQ="&Server.MapPath("database/ets.mdb")&"; Driver={Microsoft Access
Driver (*.mdb)};"
End Function
'---------------------------------------------------------------------------
' Close Database
'---------------------------------------------------------------------------
Function CloseDatabase()
cnnProject.Close
Set cnnProject = Nothing
End Function
'---------------------------------------------------------------------------
' Get User ID
'---------------------------------------------------------------------------
Function GetUserID()
GetUserID = Session("UserID")
End function
'---------------------------------------------------------------------------
' Get User Password
'---------------------------------------------------------------------------
Function GetUserPassword(strUserID)
Dim cnnLogin, rsUsers
Dim strPassword
strPassword = ""
' Create RS and query DB for quiz info
Set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.Open "SELECT * FROM Login WHERE TeamId="&strUserID&";",
cnnProject
If Not rsUsers.EOF Then
strPassword = rsUsers("Password")
End if
rsUsers.Close
Set rsUsers = Nothing
GetUserPassword = strPassword
End function
'---------------------------------------------------------------------------
' Get User Password
'---------------------------------------------------------------------------
Function GetUserEmailAddress(strUserID)
Dim cnnLogin, rsUsers
Dim strEmailAddress
strEmailAddress = ""
' Create RS and query DB for quiz info
Set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.Open "SELECT * FROM Login WHERE TeamId="&strUserID&";",
cnnProject
If Not rsUsers.EOF Then
strEmailAddress = rsUsers("Email_Address")
End if
rsUsers.Close
Set rsUsers = Nothing
GetUserEmailAddress = strEmailAddress
End function
'---------------------------------------------------------------------------
' If the user is admin - logout
'---------------------------------------------------------------------------
Function isAdmin(login)
Dim rsUsers
' Create RS and query DB for quiz info
Set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.Open "SELECT * FROM Login WHERE TeamId="&login&";",
cnnProject
If rsUsers("LogType")="Admin" Then
Response.Redirect("Logout.asp")
End if
rsUsers.Close
Set rsUsers = Nothing
End function
%> Tag: f Tag: 329858
Insert into Parent and Child in Access Relational DB
Can somebody direct me on proper syntax of SQL statement to insert
into one table that has child table in a relational database?
I can get the insert to work for the Parent, but a record also needs
to be inserted into the Child. Below is an example of my tables. I
get Table 1 to insert no problem. What I need is table 2 to populate
based on the catID from table 1 which is primarty key and selected
imgID from table 3. Thanks for your help.
EX.
Table 1
catID
imgID
venID
Table 2
catID
imgID
Table 3
imgID
imgName Tag: f Tag: 329855
Problem in Returning Recordset in ASP
I M BEGINNER IN ASP
I WANT TO RETURN TOTAL RECORDS FROM A TABLE.
THERE ARE TWO FORMS CLASS1.ASP AND CLASS2.ASP
THROUGH FIRST FORM I JUST POST THE NAME OF TABLE
SO I M WRITING THE CODE OF CLASS2.ASP
<!--#Include File = "Include/iecon.inc"-->
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<%
dim rs,rs1
class AddNum
public function showRecordCount()
tbl = Request.Form("txtTbl")
rs = con.execute("select count(*) from "&tbl)
end function
public function returnRS
tbl = Request.Form("txtTbl")
rs1 = con.execute("select * from "&tbl)
end function
end class
dim obj
set obj = new AddNum
obj.showRecordCount
Response.write("<br>")
Response.write ("Total Record is " & rs(0))
%>
<div align="left">
<table border="1" cellpadding="0" cellspacing="0" style="border-
collapse: collapse" bordercolor="#111111" width="248" height="52"
id="AutoNumber1">
<tr>
<td width="114" height="52">Addition Of Two Number using Object</
td>
<td width="128" height="52"><input type = text name = txtAdd
size="20" value = <%=a%>></td>
</tr>
</table>
</div>
<table border="1" cellpadding="0" cellspacing="0" style="border-
collapse: collapse" bordercolor="#111111" width="48%"
id="AutoNumber2">
<tr>
<td width="33%">Column1 </td>
<td width="33%">Column2</td>
<td width="34%">Column3</td>
</tr>
<%
obj.returnRS
if not rs1.eof then '/*********LINE NO 66 *****************/
while not rs1.eof
%>
<tr>
<td width="33%"><%=rs1(0)%> </td>
<td width="33%"><%=rs1(1)%> </td>
<td width="34%"><%=rs1(2)%> </td>
</tr>
<%
rs1.movenext
wend
end if
%>
</table>
</body>
</html>
MY ERROR IS
Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'eof'
/vkasp/aspClass/class2.asp, line 66
BUT WHEN I COMMENT THE IF AND WHILE LOOP PROCEDURE IT GIVES THE FIRST
RECORD BUT I WANT ALL RECORD FROM TABLE.
WHAT IS PROBLEM
PLEASE HELP ME
THANKS Tag: f Tag: 329848
SQL JOIN QUERY ISSUE
Hi all,
having problem with query below
SELECT DISTINCT dbo.logon.DRIVER_NO, dbo.booking_form.DriverNo FROM
((dbo.logon RIGHT JOIN dbo.Employees ON dbo.logon.DRIVER_NO =
dbo.Employees.DriverNo) ) LEFT JOIN dbo.booking_form ON dbo.logon.DRIVER_NO
= dbo.booking_form.DriverNo
problem is it produces more than 1 result for the driver from the
booking_form table. If a Driver is logged in then I need to show information
from the booking_form table for that driver but it produces row after row of
data. Have tried all combinations of JOIN but to no avail.
How do I select the last entry in the dbo.booking_form table for the driver
logged in?.
Regards
Simon
--
Simon Gare
The Gare Group Limited
website: www.thegaregroup.co.uk
website: www.privatehiresolutions.co.uk Tag: f Tag: 329847
How to connect to DB in another subdomain
Hi. I am looking for way to connect to database that is in another subdomain
of same hosting machine. The location of file DB here:
http://name1.syte.com
I am here:
http://name2.syte.com
The database is MS Access, I don't know if I can to connect somehow without
odbc access using regular syntax like:
connection="Provider=Microsoft.Jet.OLEDB.4.0; Data Source ....
Thanks Tag: f Tag: 329841
BOF-EOF
Consider the following code which retrieves records from a MS-Access
database table:
<%
Dim objConn
Set objConn=Server.CreateObject("ADODB.CONNECTION")
'open connection using ConnectionString
Dim strSQL1
strSQL1="SELECT......"
Dim objRS1
Set objRS1=Server.CreateObject("ADODB.RECORDSET")
objRS1.Open strSQL1,objConn,adOpenKeyset
If Not(objRS1.EOF)
Response.Write(objRS1("Col1"))
Else
Dim strSQL2
strSQL2="SELECT....."
Dim objRS2
Set objRS2=Server.CreateObject("ADODB.RECORDSET")
objRS2.Open strSQL2,objConn
Response.Write(objRS2("Col1"))
objRS2.Close
Set objRS2=Nothing
End If
Response.Write(objRS1("Col2"))
%>
Note that both the SQL queries will retrieve only ONE record. Now when
I execute the above code, ASP generates the
Exception occured.
error without pointing to any line. What could be the cause of the
error? I guess it could be because of the last Response.Write line
which spits out the value of objRS1("Col2") but I don't understand
what could be the reason for the last Response.Write line to generate
the above error.
If I add the following line
objRS1.MoveFirst
immediately after the End If line & just before the last
Response.Write line, then the error changes to
Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record.
pointing to the objRS1.MoveFirst line. Can someone please point out
what's wrong with the above code? Tag: f Tag: 329839
How This Code Works
I want an ASP app to retrieve records from a MS-Access database table
but display them in a HTML table but I want the HTML table table to
display only 7 records in a row (<tr>...</tr>) in 7 different cells
(<td>...</td>). In other words, if there are 14 records in the DB
table, the HTML table should display the 14 records in 2 rows - the
1st row displaying the 1st 7 records from the DB table & the 2nd row
displaying the remaining 7 records existing in the DB table. This is
how I did it:
------------------------------------------------
<%
On Error Resume Next
Dim objConn
objConn=Server.CreateObject("ADODB.CONNECTION")
'open the connection using ConnectionString
Dim strSQL
strSQL="SELECT * FROM MyTable ORDER BY Col1"
Dim objRS
Set objRS=Server.CreateObject("ADODB.RECORDSET")
objRS.Open strSQL,objConn
Dim iCount
%>
<table border=1>
<%
Do Until(objRS.EOF)
%>
<tr>
<%
For iCount=iCount To iCount+6
%>
<td><%= objRS("Col1") %></td>
<%
objRS.MoveNext
Next
%>
</tr>
<%
Loop
%>
</table>
------------------------------------------------
The above code does display the records how I want to display but to
be honest, I couldn't exactly understand the logic of the above code.
Can someone please explain me the logic behind the above code?
Also note the On Error Resume Next line. Though the above code
displays the records exactly how I want them to be displayed in the
HTML table, if I comment the On Error Resume Next line, then ASP
generates the
Exception occured.
error without pointing to any line. I know what's causing the error
but can't find a way out to overcome the error. Can someone please
help me resolve this error as well?
Thanks. Tag: f Tag: 329832
How does IE implement cookies?
Hello,
I'm trying to debug a problem that some users of our ASP app see that
goes away when they clear their cookies.
I've gotten a copy of their cookie for our app and have renamed it
from them@testsite[1].txt to me@testsite[1].txt. However, when I
navigate to testsite, I see it create a me@testsite[3].txt. What are
the rules as far as what gets written to the C:\Documents and Settings\
%Username%\Cookies?
When does it increment the counter that's inside the []? Are there
any articles that explain in depth how IE works with cookies?
I don't really have any problems finding articles on how to read write
cookies from within asp, etc. I
don't really need any more information on this. I need to figure out
out how the actual files work on the PC, in particular with IE6.
In theory I would think that if the problem is with information stored
in a cookie and I save another user's cookie on my machine, and change
the filename to match my user name I should be able to reproduce it,
but it doesn't seem to be working.
Thanks,
Eric Tag: f Tag: 329827
HOWTO Run multiple SQL statements from ASP/ADO to an Oracle 10g.
HOWTO Run multiple SQL statements from ASP/ADO to an Oracle 10g.
Please help,
I'm trying to write an ASP page to use ADO to run a long query against an
Oracle 10g database, to create tables, if they do not already exist. In terms
of ASP/ADO, that would be fine in a SQL Server Sense by a simply
ASP/Server-Side JavaScript as such:
var cnTemp = Server.CreateObject("ADODB.Connection");
cnTemp.Open("~~~~String for DSN~~~~");
rsTemp = cnTemp.Execute("~~~~ LONG Query ~~~~");
while (rsTemp.EOF != true)
{
~~~~~ Get data ~~~~~~
rsTemp.MoveNext();
}
In terms of the query for SQL Server it would look something like this:
if exists(~~~ MY TABLE)
begin
select 'TABLE ALREADY EXISTS' as 'RET'
end
else
begin
create table ~~~~~~
select 'TABLE CREATED' as 'RET'
end
From this, the Connection object in ADO works GREAT. The returned Recordset
object will have a single row from the multiple statements in that query
returned as the single column called 'RET'.
I need to do the same in Oracle 10g. I need to be able to run many
statements inside a single ORacle query, and have it return Recordset
compatible data, with a single column I define, like the 'RET'. But I do not
know how to do this. As best I can determine, in ORacle I would use something
like this:
SET SERVEROUTPUT ON;
declare
if not exists (~~~~ My Table)
then
create table ~~~~~;
DBMS_OUTPUT.PUT_LINE('TABLE CREATED' ;
else
DBMS_OUTPUT.PUT_LINE('TABLE ALREADY EXISTS' ;
end if;
end;
The first problem is that the PUT_LINE command does not let me have an
option to name the column as I desire. The 2nd problem is that to ORacle via
the ADO Connection object, I get an error as such on the "SET SERVEROUTOUT
ON" statement as such:
undefined(i = 0) - [Microsoft][ODBC driver for Oracle][Oracle]ORA-06550:
line 3, column 5: PL/SQL: ORA-00922: missing or invalid option ORA-06550:
line 3, column 1: PL/SQL: SQL Statement ignored
If I run the query in PL/SQL, it works, (albeit, the output returned does
not let me name the column for the PUT_LINE as I desire.
So, with all that said, how can I do this?
The keys are:
#1 A single LARGE query with multiple statements.
#2 Returns rows of data that ADO-Recordset can access.
#3 Lets one set the column names as desired.
#4 Lets me run complicated IF-THEN statements.
#5 Lets me create tables, indexes, execute grants, and create users.
#6 Same coding for SQL Server with ASP/ADO works for Oracle. IE, SOMETHING
has to happen inside the Oracle query to make it work. AND/OR because the
database is Oracle, we execute some simple QUERIES from an ADO-Connection
object ahead of time.
#7 Under no circumstance can the ADO-Command object be used. Tag: f Tag: 329824
How to generate pure XML page with ASP?
How to generate pure XML page with ASP?
This try gave me an error:
XML Parsing Error: not well-formed
Location: http://www.worldincatalog.com/manage/edit_item_xml.asp?itemid=15
Line Number 2, Column 26: <font face="Arial" size=2>
-------------------------^
<% @ Language="VBScript" %>
<%
Option Explicit
Response.Buffer = True
Response.ContentType = "text/xml"
' Start XML document.
Response.Write "<?xml version=""1.0""?>" & vbCrLf
%>
<!-- #Include file="adocon.inc" -->
<%
Set rsItem = Server.CreateObject("ADODB.Recordset")
ItemSQL = "...xxx..."
rsItem.Open ItemSQL, adoCon
if not rsItem.eof then
Response.Write "<ItemXML>" & vbCrLf
Response.Write "<ItemID>"&rsItem("ItemID")&"</ItemID>" &
vbCrLf
Response.Write "</ItemXML>" & vbCrLf
end if
rsItem.close
set rsItem = nothing
set ItemSQL = nothing
set adoCon = nothing
%> Tag: f Tag: 329816
MS XML HTTP REQUEST AND PATHS
Why ASP's MS XML HTTP request object gets another page's HTML source
without interpreting path differences. For example, if my page is:
www.test.asp/one/two/page1.asp
with XMLHTTP getting source code of page:
www.test.asp/one/page2.asp
and this latter page has a CSS with path ../include/css.css, it won't
be used in page1.asp because path will stay as it is "../include/
css.css", not "../../include/css.css" as needed for page1.asp?
So I only have one workaround to replace instances of ../ with ../../.
Any other suggestions or explanations?
Thank you Tag: f Tag: 329812
Another solution for this??
This is a script someone here helped me with a while back and I am
very grateful for the help. I am stumped however as to how to change
it slightly.
This is the script...
storyArray = Split(myStory, vbcrlf & vbcrlf)
para = storyArray(0)
'setup the loop for the first words here
Response.write "<p><span id='firstWords'>"
for i = 1 to 4
spacepos = instr(para," " )
word = left(para,spacepos)
Response.Write word 'this is the line I need to create a variable
instead
para = right(para,len(para)-spacepos)
next
'close the first words loop and print the remaining words in the first
paragraph
Response.Write "</span>" & para & "</p>" & vbcrlf
All this was designed to do it to is to take to take the first array
item (a paragraph) and enclose the first words (in this case the first
4) in style tags. It works perfectly however, instead of "printing"
the words with this line "Response.Write word", I need to instead
place the words into a variable instead of just printing them, in
other words, create a string of the first 4 words and place them into
a variable like "firstWords" or whatever so I can call on it at a
later time in the script. It should just be a simple thing but it's
not turning out this way. I'd "really" appreciate ideas.
Thanks!!
John Tag: f Tag: 329811
File Upload Problem
Problem 1> I m writing a code to upload a file There are two files
form.asp, uploadScript1.asp
Code for form1.asp
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<form method = post enctype = "multipart/form-data"
action="uploadScript1.asp" >
<input type = file name =file1 size="20" />
<input type = file name =file2 size="20" />
<input type = file name =file3 size="20" />
<input type = submit value = upload>
</form>
</body>
</html>
Code for UploadScript1.asp
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<%
Set Upload = Server.CreateObject("Persists.Upload") ' /***********This
is line No 12*******/
count = Upload.Save("C:\upload")
Response.write("File Uploaded to C:\upload")
%>
</body>
</html>
My Error is
Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid class string
/vkasp/upload1/uploadScript1.asp, line 12 Tag: f Tag: 329807
Doubt limiting user size upload
Hi, how are you doing?
I need to develop an asp application wich allow users to upload files, but I
need to limit every user folder with 10MB...
How can I do that?
not pure asp solution? each user must be a IIS/FTP user that will control
that?
Thanks
Bye Tag: f Tag: 329799
Ranges of dates
I'm sure there's a simple way to do this, but I can't seem to find it:
If today is after February 1st and before February 15th then
do valentines
elseif today is after March 1st and before March 17th then
do stpatty's day
elseif today is April 1st then
do April Fool
elseif today is after April 15th and before May 5th then
do CincodeMayo
else
just do the regular thing
end if
I know about date() and I know about datepart and I know about
month(date()) and day(date()). Right now
I do:
if month(date()) = 2 and day(date()) => 1 and day(date()) < 15 then
'do valentines
elseif month(date()) = 3 and day(date()) < 18 then
'do st pattys
elseif month(date()) = 4 and day(date()) = 1 then
'do April fool
'then I get confused about the best way to do Cinco De Mayo
else
'do the regular thing
end if
Is there an easier/better way to do this? Thanks in advance for any
tips, solutions, etc.
--
Adrienne Boswell at work
Administrator nextBlock.com
http://atlas.nextblock.com/files/
Please respond to the group so others can share Tag: f Tag: 329797
Getting option's text value
Hi,
I have a select list that gets populated from the DB. When the user
makes a selection I am able to retrieve this value via
Request.Form(...)
However, I am wondering if you can retrieve the text value using ASP??
I know this can be done in JavaScript using the options text
attribute, but it is possible in ASP?
Any input would be appreciated....Thanks! Tag: f Tag: 329796
B2B dolution in classical ASP
Hi all,
Recently, a couple of our clients have asked if it is possible for them to
pass data in xml format to our server program for processing it.
Would you please give me some guide lines or point me to a starting point
how I should do it in classical asp program.
Thank you.
--
Betty Tag: f Tag: 329793
Looking for a great designer/design team!
Hi All,
I work for a Startup based out of San Diego, CA. We are succesfull
team of entrepreneurs with a proven track record.
We have finished an initial design for a site that helps people be
more productive with social networking aspects. This means we have a
bunch of use cases and wireframes completed. We need help in putting
it all together and creating a great overall design.
We are looking for referrals from the community for designers with
solid portfolios. West Coast bases teams/indivduals are preferred.
Thanks!
Art
You can also email me individually at formless@formless.com Tag: f Tag: 329792
New Windows
www.middlesexccl.com
During testing on my home PC running XP when any of the big blue
buttons are clicked a new web page opens. If a team is selected from
the drop-down list a new page opens with the selected team details in
it.
However when deployed live, whenever any of the buttons are clicked,
not only does the new window appear for that content, but also the new
team page window appear with an error because no team has been
selected.
Can anyone explain this, and more importantly advise how I make the
live web site function as intended and how it does when testing.
PWS Tag: f Tag: 329790
ASP Debugging Text Editor
Can someone please suggest me a text editor especially for DEBUGGING
ASP scripts apart from Microsoft Visual Interdev?
I tried using Visual Interdev & created a project but Interdev
generates some error related to FrontPage extensions. I couldn't
exactly understand the error. I tried to create the project in C:
\Inetpub\wwwroot. If I just open a ASP file (by navigating to the
File-->Open File... menu), then Interdev doesn't give the option to
debug.
Please do not suggest using Response.Write, Response.End etc. I guess
I am aware of most of such debugging techniques that are globally used
by ASP developers :-) Tag: f Tag: 329783
image file cannot be printed out
Hi all,
I am not a person usually works with image file.
I am just wondering while some images in html /asp cannot be printed out?
Thank you.
--
Betty Tag: f Tag: 329778
Operation must use an updateable query - local server error
I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am
having problems getting web sites to work on my PC in Internet Explorer
using the local IIS web server. These web sites are using ASP and Access
databases.
The two errors I get are:
Operation must use an updateable query
or
Cannot modify the design of table 'TABLE_NAME'. It is in a read-only
database
Does anyone know how I can get this working so I can test my web sites
locally before uploading them to the live sites?
Thanks,
Stephen Tag: f Tag: 329776
mail program in asp
Problem 1> I m writing a mail program in asp
my first page is mail.asp where I subitting address, subject, body and
second page is send_mail.asp
Contents of Page mail.asp
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<form name = form1 action = "send_mail.asp" method = post>
To<input type = text name = "To"/ size="20" ><br/>
From<input type = text name = "from" size="20"/> <br/>
Subject<input type = text name = "subject" size="20"/></br>
Body <TextArea name = "body" rows = 5 column =20 wrap = "physical"
cols="20">
</textArea>
<input type = submit name = submit value = submit>
</form>
</body>
</html>
Contents of page sendmail.asp
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<%
'Send An Email
dim mail
Set mail = Server.CreateObject("CDO.Message")
mail.To = Request.Form("To")
mail.From = Request.Form("From")
mail.Subject = Request.Form("Subject")
mail.TextBody = Request.Form("Body")
mail.Send() ' This is Line No 19
Response.write("Mail Sent!")
'Destroy The mail Object
Set mail = Nothing
%>
</body>
</html>
My Error is :
CDO.Message.1 (0x80040220)
The "SendUsing" configuration value is invalid.
/vkasp/aspMail/send_mail.asp, line 19
I have mention the Line no 19 in above code Tag: f Tag: 329773
Real Exams
I have personally used the site [url]www.exams.ws[/url] and found it
very good. The exams are not expensive but quality wise good. When I say
quality wise good it does not mean the quality of text and diagrams but
the turn out in real live exam.
--
jhon
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------ Tag: f Tag: 329768
stored Procedure with argument
I am Beginner in ASP
Problem:I have a table named emp which fields are(id int(4), name
varchar(50), rollNo int(4))
I have to just pass the name of the emp and it will just say that
record is found or Not
My code is :
<%
nm1 = request.form("txtName")
Set cmd = Server.CreateObject("adodb.Command")
cmd.ActiveConnection = con
cmd.CommandText = "sp_search"
cmd.CommandType = adCmdStoredProc
cmd.Parameters.Append cmd.CreateParameter("nm", adchar, adParamInput)
'Just Above Line no is 19
cmd.Parameters.Append cmd.CreateParameter("flag",adInteger,
adParamReturnValue)
cmd.execute
x = cmd.Parameters("flag")
Response.write (x)
y = Cint(x)
if y = 1 then
%>
<script language = "JavaScript">
alert("Record Found")
</Script>
<%
else
%>
<script language = "JavaScript">
alert("Record Not Found")
</Script>
<%
end if
%>
My Stored Procedure is
CREATE PROCEDURE sp_search(@nm varchar(50), @flag int output) AS
if exists(select name from emp where name = @nm)
begin
select @flag = 1
return @flag
end
else
begin
select @flag = 0
return @flag
end
GO
My Error is
Error Type:
ADODB.Parameters (0x800A0E7C)
Parameter object is improperly defined. Inconsistent or incomplete
information was provided.
/vkasp/search_rec.asp, line 19 Tag: f Tag: 329767
return record set
I am beginner in ASP
1> how can I return a recordset through a function in asp.
2>Suppose there are two buttons in asp. I want if I presss the first
button then it should go to page1.asp and if I press the second button
then it should go to page2.asp. Is it possible by any way.
Please Help Me
Thank You. Tag: f Tag: 329766
Querystring issue
Hi all,
is there anyway of separating a string by either a space or + sign, I have
an sms.asp page that receives a string in this format below
http://acompany.co.uk/online/internal/InboundSms.asp?api_id=2920893&from=447912956700&to=447624813579×tamp=2007-04-07+03%3A56%3A42&text=19%2Bdavid
the last part text= I need to split into 2 parts I need to read the first
part 19 and match that to the db and then deal with the name David, I have
tried everything, is there anyway of doing this even if the string read
text=19+david if there was a way of separating the two.
Thanks in advance.
Regards
Simon Gare
The Gare Group Limited
website: www.thegaregroup.co.uk
website: www.privatehiresolutions.co.uk Tag: f Tag: 329758
click to download
Can I have this function?
When a user click on a link, my ASP page generates a text file call test.txt
containing a string of "This ia s test msg.", and then a download dialogue
appears.
Any reference for me?
Thanks in advance. Tag: f Tag: 329752
Performance Question ?
Hello:
I have a database with 300,000 records. I have two "DATE" columns and
I need to calcluate the difference and display the number of days in
one of the reports. I was wondering if this calculation of days should
be done on the fly or is it OK to have a "Difference Date"
column[Contains Number of Days] and retrieve the same ?
Their will be not more than 50 concurrent users accesing it. However,
in the next 6 months the record size is expected to reach 800,000. The
database will be hosted on a shared hosting on the internet.
Kindly share your thoughts.
Thanks. Tag: f Tag: 329751
drop down
Problem in asp
I m beginner in asp
1> I want if seleted list of drop down in asp is changed then its
related record in table should be displayed simultaniously in a single
page. Please give its full solution in asp
2> How can access the selected value of drop down in another page.
3> I want to make a search command in a Sngle page in asp.
Please Help me
Thank You. Tag: f Tag: 329743
asp JavaScript
I have a problem Some asp
Problem 1>I want to use two button in asp and want if first button is
pressed then it should go to a page and if another button is pressed
then it should go to another page.
Problem 2> I want if a button is pressed a particular function or
procedure should be call. Tag: f Tag: 329740
FormatDateTime question
I set my computer Regional Setting (Control Panel - Regional and
Language Options - Customize - Date) to dd/mm/yy. In my ASP page I do
the following:
FormatDateTime("1/20/07",2)
and it returns 1/20/07 instead of 20/1/07.
I though my setting it to 2, it will display a date using the short
date format specified in your computer's regional settings, how come
it is not ?
How can I set the string to display a date using the computer's
regional setting ?
IIS is running on my machine, I am not on a network, it is just my
machine.
Thank you. Tag: f Tag: 329738
FormatDateTime question
I set my computer Regional Setting (Control Panel - Regional and
Language Options - Customize - Date) to dd/mm/yy.
In my ASP page I do the following:
FormatDateTime("1/20/07",2)
and it returns 1/20/07 instead of 20/1/07.
I though my setting it to 2, it will display a date using the short
date format specified in your computer's regional settings, how come
it is not ?
How can I set the string to display a date using the computer's
regional setting ?
Thank you. Tag: f Tag: 329737
Load Testing and performance
We have an asp application some of which will be being ported over to
asp.net so this may be a little OT. It is having some bad performance
problems and we need to isolate which areas are causing the problems. The
main performance problems are database related i.e. timeouts and deadlocks
Some questions:
Microsoft's ACT. How is it better than the Web Stress Application Tool?
Is ACT purely .net or can be used to look at any web app.
What is a good way of assessing which pages are causing the problems.
How can I relate the performance of the database to the application. The
system has LOTS (this app has 1000's of pages) of sql passed as strings will
this affect how easy the profiler is to read.
I suspect there are lots of memory leaks, are there any tools to look at
what is being left in the memory.
I guess what I want is a tool which will identify which pages are hogging
the most resources and if they are not being released so we can look at
optimising the code. Tag: f Tag: 329733
Classic ASP and FFMPEG
Anyone have any tutorials or examples on to use FFMPEG inconjunction
with classic ASP to provide a youtube like site that includes the
ability to convert videos of different formats? Tag: f Tag: 329727
Replace commas in values in an array
Although this is a client side issue, I am also posting to asp.general
in case there is someway to do this only server side (which I would
prefer).
Here's my form:
<form method="post" action="<%=request.servervariables("Script_name")
%>"
<% for i - 0 to 4%>
Header: <input type="text" name="header" id="header<%=i%>"
onblur="function(this)"><br>
Description: <input type="text" name="description" id="description<%=i
%>" onblur="function(this)">
<% next%>
<input type="submit" value="Submit">
</form>
When the data gets returned it's something like:
header: "socks, shoes, pizza, cats, dogs"
description: "good for feet, wear with socks, cheese only, have lots
of hair, bark a lot"
Problem comes when the description or header have a comma. I need a
little javascript that will replace the comma with a semicolon client
side before it gets to
the server, preferably as they leave the field.
Any help with this would be much appreciated.
--
Adrienne Boswell at work
Administrator nextBlock.com
http://atlas.nextblock.com/files/
Please respond to the group so others can share Tag: f Tag: 329719
Simple ASP to give IP/time/username?
I am new to ASP and would like to know if anyone has a page that will
display username, time, IP
TIA - Grego Tag: f Tag: 329715
iTechArt Group - Custom Software Development and Offshore outsourcing Company
iTechArt Group - Custom Software Development and Offshore outsourcing
Company
http://www.itechart.com/
Offshore custom software development company iTechArt - Web site and
Content Management Solutions development, CMS consulting: Ektron,
Drupal and DotNetNuke
iTechArt Group provides high quality custom software development
services and offshore software development. On December 2006, iTechArt
Group became an authorized Microsoft Certified Partner. This means
that our company has been recognized by Microsoft for our vast
expertise and authorized to custom software development; provide IT
service consulting and custom business solutions.
Custom Software Development and Offshore outsourcing Company iTechArt
has worked together since 2003 to design build and deliver .NET Web
Content Management software solutions that help clients meet their
strategic objectives. We are agile oriented development partner able
to consistently deliver solid results.
iTechArt software development team assemblies specialists in the
development of custom software applications and offshore software
outsourcing services.
Working concepts of our company are based on proven approaches and
international standards used for custom software development such as
Capability Maturity Model Integration for Software Engineering (CMMI-
SW). In the same breath we have our own standpoint on software
development process management which is fully effective and
comprehensible for our clients.
iTechArt offers software development in the next main directions:
1. Custom Software Development (Offshore outsourcing for worldwide
based software development companies.)
2. Software Development for Digital Signage (Media content development
and remote displays / information kiosks Web-based software
application management.)
3. Web Site Development (E-commerce solutions, CMS/DotNetNuke/Ektron/
Drupal, Web 2.0/PHP/MySQL/AJAX, Flash/Action script/Flex and many
more.)
4. Offshore Development Center (Dedicated development team of software
developers. Our offshore development centers operate as an extension
to clients' existing software engineering business.)
Contact iTechArt ( http://www.itechart.com/ )about custom software
development, end-to-end software solutions, outsourcing software
development, custom DotNetNuke module development, DotNetNuke
consulting, dotnetnuke hosting, first class Java and .Net developers,
software application design, software testing, Quality Assurance,
functionality testing and defect analysis, performance and stress
testing, usability testing, Microsoft Media Services and Adobe Media
Flash Server solutions, digital signage solutions and custom
development, Ektron CMS400.NET developers, CMS, .NET Web Content
Management software solutions
Web:
http://www.itechart.com/
http://www.itechart.com/Pages/ProductsServices/HowWeWork.aspx
http://www.itechart.com/Pages/ProductsServices/BusinessModels.aspx
http://www.itechart.com/Pages/ProductsServices/CustomSoftwareDevelopment.aspx
http://www.itechart.com/Pages/ProductsServices/DotNetNukeModuleDevelopment.aspx Tag: f Tag: 329713