SQL Development
SQL forums discussing structured query language related questions that are platform independent. Discussions include advanced topics such as joins, stored procedures, and triggers.
answer(1) view(600) status(

)
answer(1) view(686) status(

)
Multiple select list boxes
<i><b>Originally posted by : Joe (joe_56@hotmail.com)</b></i><br />Does any one know how to use a multiple select list box to insert multiple parameters into a database table?<br /><br />Any demos o...
answer(0) view(330) status(

)
Accessing remote Access database
<i><b>Originally posted by : Michele</b></i><br />Could you suggest me some methods to access from a server a MS Access database stored in another server?<br /><br />Someone told me that I have to a...
answer(0) view(939) status(

)
Database
<i><b>Originally posted by : Smriti (gsmriti@yahoo.com)</b></i><br />Can any one tell me that what is difference between Sybase and Oracle.<br />Smriti<br />
answer(1) view(627) status(

)
ADO to Lotus Note DB
<i><b>Originally posted by : Owen Yuen (owen_yuen@em.fcnbd.com)</b></i><br />Do you know how to use ASP to make a connection with Lotus Note DB?<br /><br />Is it Lotus Note DB the same method to ac...
answer(0) view(907) status(

)
ASP incorrectly displays SQL NUMERIC 6,3 field
<i><b>Originally posted by : Allan (aspielma@yahoo.com)</b></i><br />I am using a ASP recordset to access data from SYBASE SQL.<br /><br />There is a SYBASE SQL table with certain numeric fields def...
answer(0) view(141) status(

)
Split a query result onto several pages
<i><b>Originally posted by : Tim Russell (tim@russellweb.co.uk)</b></i><br />I have seen this done loads of places but I'm not sure of the code (being a complete newbie )<br /><br />I have a page hi...
answer(1) view(268) status(

)
NEED 2 things :)
<i><b>Originally posted by : Jeremy C. Wright (jeremywright@graphic-designer.com)</b></i><br /><br />1. A solid online ASP Tutorial, as I've looked everywhere and found none that are any good (Not just as...
answer(1) view(887) status(

)
paging with stored procedures with parameters
<i><b>Originally posted by : Oliver (oliver@idea-uk.com)</b></i><br /><br />How do you use recordset paging if you are using a stored procedure that has parameters.<br /><br />ADO recordsets ...
answer(0) view(813) status(

)
I need Help!
<i><b>Originally posted by : Johnno (scripts@johnno.co.uk)</b></i><br /><br />I'm very new to ASP, and have recently tried to create a search engine for my site through a database. However, I'm having qui...
answer(0) view(567) status(

)
BLOB field error
<i><b>Originally posted by : Marcelo Almeida (maalmeid@igase.com.br)</b></i><br />Hi all, <br />I had a problem with a text field in SQL Server 7.0. When I try to get the information using GetChunk and Ac...
answer(0) view(657) status(

)
asp +ADODB2.5 is there a record limit?
<i><b>Originally posted by : Tchia (tklein@lahav.iai.co.il)</b></i><br />I tried to retrieve a recordset using SQL joining between 4 tables that produces 106k records .<br />directly at oracle client the ...
answer(1) view(563) status(

)
Autonumbered field/datatype in SQL
<i><b>Originally posted by : Filip (Filip.wilsens@pandora.be)</b></i><br />Is there a sort of autonumbered field in SQL like there is in Access? Or a special query-statement from which I can see how many entrie...
answer(1) view(90) status(

)
Optional Text Field Error
<i><b>Originally posted by : is (imransohail@earthling.net)</b></i><br />Hi!<br />I have a form field (Optional) which is set as currency field in Access 2000, If the user submits a value there is no prob...
answer(1) view(445) status(

)
SQL - types of fields
<i><b>Originally posted by : Jeff (sipek.jeff@post.cz)</b></i><br />Can somebody write me a list of all types of fields in sql? I know that there are Integer, and Varchar and that's it.<br />Please mail m...
answer(1) view(968) status(

)
adding data to database
<i><b>Originally posted by : Liwayway A. Talavera (liwayway_talavera@hotmail.com)</b></i><br /><br />Is it possible to add data to the database wherein the textbox for primary key is empty.
answer(3) view(245) status(

)
Cant Connect To SQL Server -- Error Pops Up!
<i><b>Originally posted by : G. Lemos (gplemos@email.com)</b></i><br /><br />I installed SQL 7 successfully on my computer. I'm having an error with SQL 7 when trying to enter "NEW SQL SERVER REGISTR...
answer(4) view(329) status(

)
Database
<i><b>Originally posted by : Raymond Doody (raydoody@ozemail.com.au)</b></i><br />I'm trying to implement some ASP error checks for my IIS4 and SQL intranet. I'm after some code that checks for a certain databa...
answer(0) view(459) status(

)
What are my options?
<i><b>Originally posted by : GPL (gplemos@email.com)</b></i><br /><br />Well it seems I have no real chance right now of using SQL 7 on my current computer baring getting something new, or paying out the ...
answer(0) view(316) status(

)
CreateParameter for Command object
<i><b>Originally posted by : Ted (TidyTed@yahoo.com)</b></i><br />Does any one know what the numbers in "CreateParameter" mean?<br /><br />cmd.Parameters.Append cmd.CreateParameter("U...
answer(1) view(910) status(

)
answer(0) view(504) status(

)
ASP & Sybase
<i><b>Originally posted by : N.S.Seshan (emailseshan@yahoo.com)</b></i><br /><br />Hello,<br /><br />Can anybody help me how to connect to Sybase DB from ASP. The Sybase DB is in UNIX <br /...
answer(0) view(280) status(

)
Concurrent Connection From ASP
<i><b>Originally posted by : Velayutham (s_velu@usa.net)</b></i><br />Hi,<br /><br /><br />We are developing a banking project.<br /><br />We are having two applications one is Cl...
answer(0) view(723) status(

)
database with records in different languages
<i><b>Originally posted by : Yogesh Negi (ynegi@visto.com)</b></i><br />Hi ,<br />Iam using asp for creating reports. I have oracle 8i in back end. My data base have entries in multiple langages like Kore...
answer(0) view(669) status(

)
SQL STATEMENT
<i><b>Originally posted by : Dana Williams (danaw@intel.com)</b></i><br />HI,<br /><br />I need your help in modifying the SQL Querey of the asptree provided in this site. <br /><br />I'...
answer(0) view(168) status(

)
SQL Questions
<i><b>Originally posted by : Robert Megliorino (rmeglior@alleghenytechnologies.com)</b></i><br /><br />Hello: I'm trying to do two things:<br /><br />1) How can I have a text field with more ...
answer(0) view(164) status(

)
Add a User AT NT
<i><b>Originally posted by : Marcelo Ribeiro (marcelo.ribeiro@orbitall.com.br)</b></i><br /><br />Does anybody know how do I do to add a user at Windows NT Domain ???<br /><br />Thanks for hel...
answer(0) view(829) status(

)
Binary to ASCII and visa versa
<i><b>Originally posted by : Paul Distant (pdistant@linneydesign.com)</b></i><br />I'm trying to read an ascii file to be converted into a binary file.<br /><br />How do I then read the binary file ...
answer(1) view(848) status(

)
displaying text files without using include file
<i><b>Originally posted by : cem tekin (tekin65@yahoo.com)</b></i><br />hi, i'm quite new to asp. i wonder if there's anybody who do have an answer to my problem.<br /><br />i'm trying to insert one...
answer(1) view(72) status(

)