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
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
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(wait for best answer)
Who hosts asp and global 4 free?
<i><b>Originally posted by : Pirazy</b></i><br />Who hosts asp and global.asa 4 free?<br /><br />Plz help!
answer(0)  view(242)  status(wait for best answer)
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(wait for best answer)
Display database results in browser in an excel spreadsheet
<i><b>Originally posted by : Clive Hoggar (cwh@le-web.net)</b></i><br />I am struggling! <br />I want to send the results of search of an Access database (OK I admit I am using Frontpage 2000 to generate ...
answer(1)  view(514)  status(wait for best answer)
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(wait for best answer)
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(wait for best answer)
i need a form that replies back to the user and writes data to the access file
<i><b>Originally posted by : skoja (sarajevo99@hotmail.com)</b></i><br />did anyone came accross with the form that does just that?? thanks<br />
answer(0)  view(832)  status(wait for best answer)
Count Property-Multiple Values in Same Field Not Working
<i><b>Originally posted by : chris (chrisveres@yahoo.com)</b></i><br />I need to count different values from the same field and have them print out four separate counts. I also need to be able to sort these by...
answer(0)  view(647)  status(wait for best answer)
 
Home - About Infoqu - Contact - Privacy Statement - Link to Infoqu - Bookmark Infoqu

Copyright 2007-2008 by Infoqu. All rights reserved