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.
PARSE COMMA SEPERATED TEXT
<i><b>Originally posted by : RAJ (rajkedda@hotmail.com)</b></i><br />How do I separate a comma separated text into an array.<br />for example:<br />states=st1,st2,st3,st4,st5 <br /> to<br ...
answer(1) view(659) status(

)
How to show logged in user info on screen
<i><b>Originally posted by : Aspen (sfreus@quicknet.nl)</b></i><br /><br />That's my question. I'm looking for a script that shows the user's info when he/she is logged in.<br />Data is stored in ac...
answer(0) view(641) status(

)
How to show logged in user info from db
<i><b>Originally posted by : Aspen (sfreus@quicknet.nl)</b></i><br /><br />That's my question. I'm looking for a script that shows the user's info when he/she is logged in.<br />Data is stored in ac...
answer(0) view(635) status(

)
Dictionary in the Application object
<i><b>Originally posted by : Paul Distant (pdistant@linneydesign.com)</b></i><br />In my application I'm trying to prevent a user logging into the application twice. I have the idea of using the dictionary obje...
answer(0) view(157) status(

)
encryption
<i><b>Originally posted by : venkat (venkat_karnati@hotmail.com)</b></i><br />Hello guys,<br /> Is it possible to encrypt user names and password in SQL database table.<br /><br />thanks in ...
answer(0) view(975) status(

)
ODBC driver problems with Access / ASP
<i><b>Originally posted by : ADEW (asp@adew.co.uk)</b></i><br />I'm having problems getting an ASP file to open up my Access database on both W2000 and W98. The Access is a new install in all cases, and is Acc...
answer(1) view(313) status(

)
access2000 + asp website
<i><b>Originally posted by : gilles (gilles@tatalia.com)</b></i><br />i have a problem with access!<br /><br />i make an asp website with a mdb database...<br />it works nice... but when i ope...
answer(1) view(245) status(

)
error early binding ado recordset object
<i><b>Originally posted by : adam harbour (aharbour@yahoo.com)</b></i><br />Hi<br />I am trying to create an ado recordset object.<br /><br />dim rs as object<br />rs= server.CreateObjec...
answer(0) view(907) status(

)
how to insert primary key field into access using asp
<i><b>Originally posted by : goof</b></i><br />I wish to insert a primary key field into and access database.I also want this field(number) to auto-increment everytime a new record is added.I'd like to do this ...
answer(1) view(647) status(

)
SQL join problems
<i><b>Originally posted by : Terry Inniss (elk@caribsurf.com)</b></i><br />I have three tables that can be join but not by primary key. I have some inner joins to link them but my asp crashes on the said SQL st...
answer(1) view(849) status(

)
Help for SQL-Query
<i><b>Originally posted by : Guenter Podgornik (guenter.podgornik.borgg@schulen.vol.at)</b></i><br /><br />I have an access database with two tables (author [AuthorID,FirstName, SecondName, Birth, Biograp...
answer(1) view(578) status(

)
select RND entry?
<i><b>Originally posted by : Para</b></i><br /><br />hi , here's my proberlem ...<br /><br />i need to connect to a DB , and select a RND entry based on fields requirements ..???<br />sa...
answer(0) view(211) status(

)
Selecting random field !
<i><b>Originally posted by : Para (o0_Para_0o@hotmail.com)</b></i><br /><br />hi , here's my proberlem ...<br /><br />i need to connect to a DB , and select a RND entry based on fields require...
answer(0) view(539) status(

)
Urgent!
<i><b>Originally posted by : Namita (namitadas@yahoo.com)</b></i><br />Hi,<br /><br />I have a table with <br /><br />CodeID<br />CodeDescription<br />CodeDefinition<br /&...
answer(0) view(809) status(

)
Disconnected recordsets question... Please help!
<i><b>Originally posted by : Markus (markusss@evitech.fi)</b></i><br /><br />Hi<br />Im using ms acces and IIS 5( as webhosting service).<br />Ii am trying to update a disconnected recordset t...
answer(0) view(634) status(

)
Trigger
<i><b>Originally posted by : Murugan (mugas25@yahoo.com)</b></i><br /><br />How to write a trigger in sql?<br />
answer(1) view(108) status(

)
Displaying database records
<i><b>Originally posted by : meldrape (meldrape@texas.net)</b></i><br /><br />Greetings,<br /><br />I have a SQL table we'll call CATEGORY and an ASP pulling from the database. I have 9 diffe...
answer(1) view(865) status(

)
wordwrap problems with response.write
<i><b>Originally posted by : andrew (harrison@tiscalinet.it)</b></i><br />When the results of my database search are printed out, the text is just printed on one long line and does not wrap. How can I alter:<...
answer(1) view(245) status(

)
Updating the wrong database
<i><b>Originally posted by : Jeff (ravens@lammies.freeserve.co.uk)</b></i><br /><br />Hi, i am currently developing a site. I am using<br />win98 pws on my computer to test my site.<br />I bui...
answer(1) view(139) status(

)
I need to know how i can make a DBConn Descending
<i><b>Originally posted by : Fredrik (psyk00@chello.se)</b></i><br />i want my news from a DB come Descending<br />Hey i dont want old news at the beggining<br />LOL :-)<br />NEED help here<...
answer(1) view(457) status(

)
wordwrap with recordset
<i><b>Originally posted by : andrew (harrison@tiscalinet.it)</b></i><br /><br />when I insert data into my database it doesn't wrap when called by a search.It is all presented in one long line.<br />...
answer(1) view(239) status(

)
Creating Table with a variable name
<i><b>Originally posted by : Simon (schoong@onebox.com)</b></i><br />I wanted to create a table in a procedure and the table name will be passed to the procedure. Can I create a table with a variable name? I've...
answer(1) view(613) status(

)
Need help with SQL error. Driver related I think.
<i><b>Originally posted by : Michael (mtm@houston.rr.com)</b></i><br />I've got a problem with an ASP based website that was written by somebody else. The owners want a new feature added so I'm trying to figure...
answer(1) view(922) status(

)
answer(0) view(242) status(

)
submitting to multiple tables
<i><b>Originally posted by : Frank Luciod (flucido@baygroup.com)</b></i><br />I am curently developing a database driven web site thatwill ask users to input a large amount of data. On any one page there will b...
answer(0) view(111) status(

)
answer(1) view(514) status(

)
Display database fields
<i><b>Originally posted by : MM (manal.milad@itworx.com)</b></i><br /><br />I am new to ASP+ and I need to display fields from a table. I don't want to use a Datagrid nor a DataList. I want to display the...
answer(0) view(171) status(

)
SQL-7, varchar, size 8000
<i><b>Originally posted by : Gregory (gmoldavsky@dsg-us.com)</b></i><br />In SQL_7 I create in the table field: <br />Datatype: varchar Length: 8000<br />I trying to put there string (4500 characte...
answer(0) view(320) status(

)
answer(0) view(832) status(

)
answer(0) view(647) status(

)