CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting – 3 Months Free!



Zone: > NEWSGROUP > Asp.Net Forum > migration_to_asp.net.migrating_from_cold_fusion_to_asp.net Tags:
Item Type: NewsGroup Date Entered: 5/12/2004 2:15:22 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 0 Views: 26 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
1 Items, 1 Pages 1 |< << Go >> >|
ASPworkedforme
Asp.Net User
SQL Select Statement5/12/2004 2:15:22 PM

0/0

hello I was wondering if anyone could help me on this one.

I have this select statement and need to change it to ASP
could anyone help please...

Select Distinct AppDesc
From AppDesc,Appln
Where Appln.AppRefNo = AppDesc.AppRefNo and #Form.subyear# Between FrmYr and ToYr
Order by AppDesc

would this be proper translation?

Select Distinct AppDesc
From AppDesc, Appln
Where Appln.AppRefNo = AppDesc.AppRefNo and "& Request.Params("ddlYear") &" between FrmYr and ToYr
Order by AppDesc
1 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Java All-in-one Desk Reference for Dummies Authors: Doug Lowe, Barry Burd, Pages: 882, Published: 2007
Beginning Access 2003 VBA Authors: Denise Gosnell, Pages: 552, Published: 2004
SQL Server 2005 Bible Authors: Paul Nielsen, Pages: 1293, Published: 2006
Sams Teach Yourself Active Server Pages 3.0 in 21 Days Authors: Scott Mitchell, James Atkinson, Pages: 800, Published: 2000
Ivor Horton's Beginning Java 2, JDK: JDK 5 Edition Authors: Ivor Horton, Pages: 1470, Published: 2004
Access 2002: The Complete Reference Authors: Virginia Andersen, Pages: 1220, Published: -1
Delivering Business Intelligence with Microsoft SQL Server 2005 Authors: Brian Larson, Pages: 776, Published: 2006
Oracle SQL*Plus: The Definitive Guide Authors: Jonathan Gennick, Pages: 502, Published: 1999
Developing and Implementing Windows-based Applications with Visual Basic .NET and Visual Studio .NET Authors: Kirk Hausman, Kalani Kirk Hausman, Mike Gunderloy, Ed Tittel, Pages: 544, Published: 2003
Visual Basic .NET Database Programming: database programming Authors: Rod Stephens, Pages: 405, Published: 2002

Web:
SQL SELECT Statement This chapter will explain the SELECT and the SELECT * statements. The SQL SELECT Statement. The SELECT statement is used to select data from a database. ...
SQL WHERE Clause Well organized easy to understand SQL tutorial with lots of examples. Including PHP, ASP, ADO, Oracle, Access, ... We use the following SELECT statement: ...
SQL Tutorial [SELECT Statement Basics] The SQL SELECT statement queries data from tables in the database. The statement begins with the SELECT keyword. The basic SELECT statement has 3 clauses: ...
SELECT You can select rows from a single partition of a partitioned table by specifying the keyword PARTITION in the FROM clause. This SQL statement assigns an ...
SQL: SELECT Statement The SELECT statement allows you to retrieve records from one or more tables in your database.
SQL Tutorial: SELECT Statement The general form for a SELECT statement, retrieving all of the rows in the table is: ... There are six logical operators in SQL, and after introducing them, ...
SQL SELECT Statement This section introduces the fundamental commands of SQL, SELECT and FROM.
SQL Tutorial [SELECT Statement Extended] In the previous subsection on basic Select statements, column values are used in the select list and where predicate. SQL allows a scalar value expression ...
Select (SQL) - Wikipedia, the free encyclopedia A SQL SELECT statement returns a result set of records from one or more tables. [1] [2]. It retrieves zero or more rows from one or more base tables, ...
SQL SELECT Statement How to use sql select statement. How to select rows in SQL.

Videos:
SQL Server 2008 and using Transact SQL (TSQL) If you want to be good at working with databases, strong knowledge of TSQL is a must. In this important video, we start off with a little background ...
029i-Oracle8i, 9i, and 10g More New Features-Using Native Dynamic SQL Your organization wants you to write a stored procedure to pass the table name and get back the number of records that table contains. The SELECT sta...
VS 2008: problem - parameter source does not change When I want to specify a custom SQL statement I can't define parameters and when I want to select "parameter source" it doesn't change to anything ex...
An Introduction to SQLite Google TechTalks May 31, 2006 Richard Hipp ABSTRACT SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQ...




Search This Site:










datagrid

converting coldfusion to asp.net

how to cfoutput in asp.net ???

dumb, simple cf to asp.net questions.

asp vs cf

<cfquery> vs. asp.net

specification for cfm to .net migration

is it possible to duplicate cf schedule in asp.net?

decrypting passwords encrypted using cold fusion encrypt

silly question...

three selects lists (dropdowns) related

web.config similar to application.cfc (or application.cfm)

asp to clear cache?

comparison: cold fusion vs. asp.net

who is ben forta's asp.net?

justifying the move!!!

questionnaires

getting inforamtion from coldfusion pages in asp.net page

sql select statement

varbinary datatype in asp.net

functions in coldfusion and asp.net

migrating from coldfusion to asp.net

coldfusion site navigation.... how do i do this in asp.net?

migrate cf to asp.net2

<cfoutput> group attribute

conversion from coldfusion to asp.net - please help

cfc in asp.net

cf and .net framework side by side?

convert coldfusion pages to asp.net

anybody else miss being able to quickly get a webapp up?

  Privacy | Contact Us
All Times Are GMT