CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Sql: How do assign a value from sql-table to a field in another table or a variable?

Print topic Send  topic

Author Message
=?iso-8859-15?Q?K=E5re_Simensen?=
Posted: 01/28/2006, 3:45 AM

Here is my code !!!!:
dim sql,sql2
dim Nyteller, forrigeteller,Iaar
dim conn
dim errormessage

set conn =3D NEW clsDBAltahavnKF
Iaar =3D year(date)
conn.open
sql =3D "select Teller from telleverk where arstall =3D"& Iaar
conn.execute(sql)
errormessage =3D CCProcessError(conn)
if errormessage <> "" then
response.write("Feil: "&Errormessage)
end if
Nyteller =3D Teller

Teller is a field in my Table Telleverk
but when I try to assign the value in Teller to Nyteller I got
a errormessage: Variable Is undefined "teller" - Why??

I have trid thsi to: Nyteller =3D Telleverk.Teller - but the errormess=
age =

is the same, this time Telleverk is not define

Any one who can help me ?


-- =

Sendt med Operas revolusjonerende e-postprogram: http://www.opera.com/ma=
il/

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.