Home > SQL Development

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.
Ask Question About SQL Development
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
Updating a Access 2000 Database with Asp and I'm getting a Syntax error?
<i><b>Originally posted by : Stephen King (slacker@surrealist.com)</b></i><br />Here is my code. it work on other pages but they don't have dates and times in them. any help is appreciated<br /><%<b...
answer(1)  view(292)  status(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
How do you execute a DTS package from a SQL statement.
<i><b>Originally posted by : Scott Gach (gach.scott@principal.com)</b></i><br />Is there any way to do this.<br /><br />Execute a DTS package from a SQL statement.
answer(0)  view(603)  status(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
 
Home - About Infoqu - Contact - Privacy Statement - Link to Infoqu - Bookmark Infoqu

Copyright 2007-2008 by Infoqu. All rights reserved