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.
How to access ORACLE?
<i><b>Originally posted by : umit (yilmaz@ag.army.net)</b></i><br />I wonder how to access ORACLE Database by using ASP. I know that ORACLE system is much <br />more different than SQL Server or Access. H...
answer(0) view(335) status(

)
ADODB.Recordset error
<i><b>Originally posted by : dale (dale@duluth.com)</b></i><br /><br />Hi all<br />I keep getting the error:<br /><br />ADODB.Recordset error '800a0bb9'<br />Arguments are of the w...
answer(0) view(279) status(

)
Sorting Question
<i><b>Originally posted by : Paul White (pwhite@yahoo.com)</b></i><br />I've come across a perplexing problem.<br />I'm doing a binary search which requires that my universe and subset be sorted identical...
answer(0) view(471) status(

)
how to connect excel database using asp
<i><b>Originally posted by : sangeeta (life01_01@yahoo.com)</b></i><br />I have some information in the format of excel file and I want to reterive that information, in a form using asp and html<br />
answer(1) view(751) status(

)
ASP mail + Attchment
<i><b>Originally posted by : Olof Jolom (olof.jolom@odata.se)</b></i><br />How do I do to send one or more files with my mail?
answer(2) view(594) status(

)
URGENT -->ASP & DLL VB
<i><b>Originally posted by : jose antonio (jaleo@akilandias.com)</b></i><br />dear all!!!<br />I have a function in a dll of Visual Basic that return a recordset.<br /><br />How can i take thi...
answer(0) view(736) status(

)
global
<i><b>Originally posted by : yosef halevy (ry2774ae@isdn.net.il)</b></i><br />i have a global.asa file that works with an asp file and a database-access.i need to know why if the database has his sessionsession...
answer(0) view(810) status(

)
sql query ?
<i><b>Originally posted by : mike robb (aspfree@js-examples.com)</b></i><br /><br />I have 2 tables that I would like to query against both with one sql command.<br /><br />this is what i have...
answer(2) view(15) status(

)
Learning how to write Stored Procedures
<i><b>Originally posted by : Jeff Coon</b></i><br /><br /> Does anyone have a good tutorial for learning about stored procedures? I've gone through some tutorials on how to write SQL statements, and I'm...
answer(0) view(314) status(

)
autonumbers
<i><b>Originally posted by : sam (sam.howe@siemens.ie)</b></i><br /><br />I am using asp to connect to a database, via a HTML file.<br />I need to know how to generate an Autonumber when I'm creatin...
answer(1) view(377) status(

)
answer(1) view(292) status(

)
Image Map and Database
<i><b>Originally posted by : Mitch Palmer (mstrmitch@hotmail.com)</b></i><br /><br />I have an htm page that has an image map on it. I want to be able to click onto part of the image and bring up specific...
answer(0) view(382) status(

)
ASP to Access
<i><b>Originally posted by : Holly Sammons (sammons@ocpl.lib.ny.us)</b></i><br /><br />I am a public librarian with an intermediate level understanding of Access. What I need to do <br />is take an...
answer(0) view(247) status(

)
Logging of access rights
<i><b>Originally posted by : John (nozomi2310@excite.com)</b></i><br />Is any any way to log who have been to which asp files either through asp codes or sql server. I need to do that.Please help mi....Thanx.&l...
answer(0) view(696) status(

)
Converting MDB into text !!!!!!!!!!
<i><b>Originally posted by : Vishal Gupta (vishalg@graceworks.com)</b></i><br />hi friends<br />i am finding problem in making a COM to convert an entire database(MS-ACCESS) into a single text file and vi...
answer(1) view(686) status(

)
records affected
<i><b>Originally posted by : santy (sanambati.satyam@healtheonindia.com)</b></i><br />Here I am with a problem ....Here it goes<br /> I am need of retrieving rows affected<br /> by my SQL statemen...
answer(0) view(751) status(

)
Converting MDB into text !!!!!!!!!!
<i><b>Originally posted by : Vishal Gupta (vishalg@graceworks.com)</b></i><br />hi friends<br />i am finding problem in making a COM to convert an entire database(MS-ACCESS) into a single text file and vi...
answer(0) view(381) status(

)
Cannot find domain from my .asp stored in SQL 7.0
<i><b>Originally posted by : Tammy (tlnet2000@yahoo.com)</b></i><br />I re-install WIndows NT 4.0, SQL 7.0. Then try to run my company's web site (intranet) which <br />is written by asp. However, in my m...
answer(0) view(405) status(

)
Question: Passing Text Quotes into Sql Database
<i><b>Originally posted by : Phil D. (phild@cuttingedgemedia.com)</b></i><br />Hello All,<br /><br />I am trying to pass qoutes from an HTML form to a SQL database. The problem that I am experiencin...
answer(0) view(620) status(

)
Hosting for ASP , COM , MTS and sQL Server 7
<i><b>Originally posted by : veena (veenasugumar@hotmail.com)</b></i><br />Hi!<br /><br />Can someone suggest some reliable hosing providers who can host our portal which is being built with ASP, SQ...
answer(1) view(342) status(

)
sintaxis
<i><b>Originally posted by : carlos de pedro (carlosdpa@uninet.es)</b></i><br />Hi,<br /><br />What磗 wrong in this code:<br /><br />mySQL="select * from usuarios where Idusuarios =r...
answer(1) view(255) status(

)
checking against a session variable
<i><b>Originally posted by : Simon (simonhewitt2000@hotmail.com)</b></i><br />what is the correct syntax to check against a session variable.<br /><br />my sql looks like this:-<br />mySQL=&qu...
answer(1) view(175) status(

)
SQLOLEDB and distributed transactions
<i><b>Originally posted by : Jignesh (codehunt@yahoo.com)</b></i><br />I have to connect two independent MS SQL database servers. For this I have configured a link sever from one server to another using Client ...
answer(0) view(656) status(

)
server hangs when some fields are accessed
<i><b>Originally posted by : JJ (bluekick@usa.net)</b></i><br />i have identical databases and tables in 2 machines, one running SQL server 7, and the other running sql server 2000. When my asp code points to t...
answer(0) view(861) status(

)
answer(0) view(603) status(

)
DropDownList Selection from DataSet
<i><b>Originally posted by : John Diamantis (y.diamantis@altanet.gr)</b></i><br /><br />Hi, there.<br /><br />I have a problem here.<br /><br />I Bind a DropDownList from a DataSet...
answer(1) view(392) status(

)
sql server 2000 connection
<i><b>Originally posted by : may (carreramj@yahoo.com)</b></i><br />Can you please tell me the syntax of sql server 2000 connection?<br />
answer(0) view(263) status(

)
How can update and add to multiple tables?
<i><b>Originally posted by : Richard (rsweeting@bahamas.net.bs)</b></i><br />How can i update a table and at the same time add to another table.<br /><br />I used the code from this site:<br />...
answer(1) view(688) status(

)
Syntax error in SQL Statement?
<i><b>Originally posted by : Simon (simonhewitt2000@hotmail.com)</b></i><br /><br />Can anyonr tell me what the problem is?<br /><br />UPDATE newsfile SET newsid = 9', newstitle = 'Council Mem...
answer(1) view(186) status(

)
Updating with formatted SQL
<i><b>Originally posted by : Simon (simonhewitt2000@hotmail.com)</b></i><br /><br />I run a small site with news posts that my members can add to, I am trying to implement an update feature, I have create...
answer(1) view(766) status(

)