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
Database Encryption
<i><b>Originally posted by : Victor (boy2loveu@yahoo.com)</b></i><br />I am working with highly sensitive data. How can I Encrypt my databse? <br /><br />Thanks in advance.<br />
answer(1)  view(393)  status(wait for best answer)
InStr on ObjRS.Fields?
<i><b>Originally posted by : Erik (erik.j.lillestol@wellsfargo.com)</b></i><br />I'm trying to use InStr on records in the Fields collection to selectively write column names as follows:<br /><br />...
answer(1)  view(565)  status(wait for best answer)
error in sql
<i><b>Originally posted by : stephen (profliz@hotmail.com)</b></i><br />my coding:<br /><br />SQL1 = "SELECT m_id, m_email, m_subject, m_numReplies, m_entrydate FROM messages "<br />...
answer(1)  view(517)  status(wait for best answer)
asp/access database username and password authentication
<i><b>Originally posted by : william (wmatthers@yahoo.com)</b></i><br />I am having a problem with creating a script that verifies whether or not a user has an account in a database table. If so he or she gets ...
answer(1)  view(740)  status(wait for best answer)
Sort by column SQL Question
<i><b>Originally posted by : Heather (hpoplin@hertz.com)</b></i><br />Does anyone know to code to sort by a column in a table when the column is clicked on? I saw a page that did that. I've read their code an...
answer(1)  view(479)  status(wait for best answer)
ASP, ADO, Access 2000, client cursors, adlockpessimistic issue.
<i><b>Originally posted by : Mark Rodrigo (mark.rodrigo@towill.com)</b></i><br />Hello all:<br /><br />I am using ADO within ASP to update my Access 2000 db for a multi-user application,<br />...
answer(1)  view(460)  status(wait for best answer)
How to connect to oracle using ADO in ASP.net
<i><b>Originally posted by : krishna kumar (krishna@dcons.com)</b></i><br />Hi,<br />pls can i connect to oracle using the same code as in ASP,or else let me know the code,<br />thanx,<br />Kr...
answer(1)  view(305)  status(wait for best answer)
How to migrate from ADOX to ADO.Net ?
<i><b>Originally posted by : Yongkuk Kwon (autotech@dreamwiz.com)</b></i><br />I want to get all Tables Infomation from some database. I used ADOX for it. But In ADO.Net,<br />How can I get these infomati...
answer(0)  view(297)  status(wait for best answer)
Returning autonumber from Accesss97
<i><b>Originally posted by : Tim (Tim34@hotmail.com)</b></i><br />I am inserting some data into a table in Access97.<br />After the insert, I need to find the autonumber that has been generated. Any ideas...
answer(2)  view(663)  status(wait for best answer)
Accessing Access 2000 DB with ASP
<i><b>Originally posted by : Jeroen van Gils (j.vgils@planon.nl)</b></i><br />Hello,<br /><br />What i'm trying right now is to connect an Access 2000 Database to my ASP but for some reason the conn...
answer(2)  view(918)  status(wait for best answer)
Please help: Too few parameters. Expected 7
<i><b>Originally posted by : Yousef Al-Abdali (aseer53@hotmail.com)</b></i><br />I was trying to get the details of a link by passing the ID of that topic to another page, however, I got this error: <br />...
answer(0)  view(157)  status(wait for best answer)
Not specified
<i><b>Originally posted by : SRIDHAR (impal@cbsinc.com)</b></i><br />how to assign array of values to empty recordsets using ASP?<br />
answer(0)  view(951)  status(wait for best answer)
Querying Database without Submitting Form
<i><b>Originally posted by : Jane (janepeihong@yahoo.com)</b></i><br /> I'm currently working on an online form. The first field on the form is a company name field, which is in the form of a drop-down list. ...
answer(1)  view(91)  status(wait for best answer)
Pointers and Data objects
<i><b>Originally posted by : Robert (robertg@speakout.com)</b></i><br />I am in a situations where I may have to set and object to another object, which holds a data set. What I want to know is if I set a new ...
answer(0)  view(174)  status(wait for best answer)
Pointers and Data objects
<i><b>Originally posted by : Robert (robertg@speakout.com)</b></i><br />I am in a situations where I may have to set and object to another object, which holds a data set. What I want to know is if I set a new ...
answer(0)  view(141)  status(wait for best answer)
Many-to-many relationships and checkboxes
<i><b>Originally posted by : Linda (lindas_hansson@hotmail.com)</b></i><br />Hi! I've got a problem that I desperately need help with. I've got an Access database with two tables, let's call them girls and boys...
answer(1)  view(372)  status(wait for best answer)
How to start lessons??
<i><b>Originally posted by : Maverick (mcchen@quicknetcom.com)</b></i><br />i'm a newbie in SQL server 7.0 ,anyone could point me to some good sites that tat give free tutorials on creating database in the fast...
answer(1)  view(231)  status(wait for best answer)
Simple Question: Checking to see if username and password exist
<i><b>Originally posted by : East (alan.easton@unn.ac.uk)</b></i><br />Hi All,<br /><br />I have a registration form for new users. They choose a username and password before they submit their detai...
answer(1)  view(852)  status(wait for best answer)
Additional Licences for MS-SQL when used with asp?
<i><b>Originally posted by : Simon (schoong@onebox.com)</b></i><br />Hi guys,<br />I was informed by my ISP that when I use MS-SQL with IIS, I'm required to purchase additional Internet connection licence...
answer(0)  view(13)  status(wait for best answer)
ADO+ not populating datagrid
<i><b>Originally posted by : David Keaveny (david.keaveny@cassium.com)</b></i><br />I have a .aspx file with a simgle datagrid on it that is supposed to be populated from a database with some VB code. However, ...
answer(0)  view(46)  status(wait for best answer)
ASP build page to send by email
<i><b>Originally posted by : karine (karine@tista.com)</b></i><br /><br />I want to send a page build with ASP by e-mail, I don't want to have a link to this page.<br /><br />Thanks for your i...
answer(0)  view(803)  status(wait for best answer)
ADO.net data binding with an Access DSN
<i><b>Originally posted by : Alex (machine_a_laver_2000@yahoo.com)</b></i><br />Hi, <br /><br />How can I use ADO.net and databinding stuff with an Access database ...<br />I fail to connect w...
answer(1)  view(146)  status(wait for best answer)
Date problem with SQL Server
<i><b>Originally posted by : Paramesan Mathen (160rept@atlas.wits.ac.za)</b></i><br />Hi,<br /><br />In my web application I have a table which holds a "Last updated" column.<br />&l...
answer(0)  view(392)  status(wait for best answer)
160rept@atlas.wits.ac.za
<i><b>Originally posted by : Paramesan Mathen (Date problem with SQL Server)</b></i><br />Hi,<br /><br />In my web application I have a table which holds a "Last updated" column.<br /&g...
answer(0)  view(486)  status(wait for best answer)
Help with asp
<i><b>Originally posted by : Chris (chalverson@norcorp.com)</b></i><br /><br />I have written a a web application that does simple searches on a database, I have it linked to our nt server loggin so only ...
answer(0)  view(400)  status(wait for best answer)
Duplicating data seperated by a comma on insert and update..
<i><b>Originally posted by : kyoung (k_d_young@hotmail.com)</b></i><br />When I am inserting data it ends up duplicating itself with a comma seperating it. Example: When I insert "Test" it turns up to...
answer(0)  view(685)  status(wait for best answer)
postcode locator
<i><b>Originally posted by : alex (alex@ianjenn.freeserve.co.uk)</b></i><br />I need to set up a postcode database so that I can input a postcode and search all other postcodes within a specified distance. Does...
answer(1)  view(97)  status(wait for best answer)
Problem no return back after insert into database
<i><b>Originally posted by : hemie (hemie@jic.net.my)</b></i><br /><br />I am working with no duplicate data. How can I do?<br /><br />Thanks...
answer(0)  view(209)  status(wait for best answer)
How to get a different random number?
<i><b>Originally posted by : Bob Lai (laipy966@pchome.com.tw)</b></i><br />I have problems in getting a different random number using the randomize function or n=Int(10*rnd())+1.<br />How can I check with...
answer(0)  view(801)  status(wait for best answer)
Beginner ASP Access question
<i><b>Originally posted by : Julia (comp6512@earthlink.net)</b></i><br />Hi, <br />I am studying ASP using "Beginning Active Server Pages 3.0" by WROX.<br />I am using NT4.0 and Access 200...
answer(1)  view(820)  status(wait for best answer)
 
Home - About Infoqu - Contact - Privacy Statement - Link to Infoqu - Bookmark Infoqu

Copyright 2007-2008 by Infoqu. All rights reserved