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.
Convert rows into columns
Hello, I have a problem formatting some data. What I have so far is a query that returns me two columns. One is the name of some "assets" and the other is a count of all the assets associated with that name. eg servers ...
Hello, I have a problem formatting some data. What I have so far is a query that returns me two columns. One is the name of some "assets" and the other is a count of all the assets associated with that name. eg servers ...
answer(1) view(233) status(
)
)
connect SQL database to VB.net
Hye, we're trying to connect a SQL database to a simple form in VB.net We've tried the following code: Dim myConnection As SqlConnection Dim myCommand As SqlCommand Dim myDataGrid As DataGrid myConnection = New SqlConnection("Ser...
Hye, we're trying to connect a SQL database to a simple form in VB.net We've tried the following code: Dim myConnection As SqlConnection Dim myCommand As SqlCommand Dim myDataGrid As DataGrid myConnection = New SqlConnection("Ser...
answer(0) view(388) status()
)
Data with spaces is getting dropped
<i><b>Originally posted by : Kelly Ryan (kelly.ryan@mailcity.com)</b></i><br /><br />I am pulling a record out of a SQL database and populating onto a page using a RecordSet. My problem is anything that ...
<i><b>Originally posted by : Kelly Ryan (kelly.ryan@mailcity.com)</b></i><br /><br />I am pulling a record out of a SQL database and populating onto a page using a RecordSet. My problem is anything that ...
answer(2) view(780) status()
)
Before i get ahead of myself.. database design critque plllleeassee...
Scope of project:create simple browse down (+search) engine/site for various telecom and networking parts arranged by manufactuer then brand then part to show a list of vendors that carry said product arranged by price and reorderable.. ...
Scope of project:create simple browse down (+search) engine/site for various telecom and networking parts arranged by manufactuer then brand then part to show a list of vendors that carry said product arranged by price and reorderable.. ...
answer(9) view(234) status()
)
In need of an INSERT
I can't the following INSERT statement to work... Dim oConn, rs, strSql, filePath filePath = Server.MapPath("cust_users.mdb") Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "Provider=Mi...
I can't the following INSERT statement to work... Dim oConn, rs, strSql, filePath filePath = Server.MapPath("cust_users.mdb") Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "Provider=Mi...
answer(6) view(709) status()
)
one more problem...
Hi, I just stumbeled over another problem i hope you can help me with Having the following tables: Dept ------- *Deptname Owes Emp ------ *Name DeptName (foreign key: Dept.DeptName) Car ------ *CarNr OutTo (foreign key: Emp.Na...
Hi, I just stumbeled over another problem i hope you can help me with Having the following tables: Dept ------- *Deptname Owes Emp ------ *Name DeptName (foreign key: Dept.DeptName) Car ------ *CarNr OutTo (foreign key: Emp.Na...
answer(5) view(914) status()
)
order by an alias?
I have problems with the following sql query: SELECT c.CarNr, c.Make, c.OutTo, c.OutOn, (t.Date - c.OutOn)+1 AS Days, c.Cost, Days * c.Cost AS Total FROM Cars c, Today t WHERE c.OutOn <> null ORDER BY Total Asc I get the error: ...
I have problems with the following sql query: SELECT c.CarNr, c.Make, c.OutTo, c.OutOn, (t.Date - c.OutOn)+1 AS Days, c.Cost, Days * c.Cost AS Total FROM Cars c, Today t WHERE c.OutOn <> null ORDER BY Total Asc I get the error: ...
answer(4) view(247) status()
)
Joining 3 tables with 1 to many records for a distinct recordset
I want to return a set of unique records from Three tables where one table holds distinct Student information, and another holds 1 to many records for each Student according to the number of classes being taken, and the third holds the numb...
I want to return a set of unique records from Three tables where one table holds distinct Student information, and another holds 1 to many records for each Student according to the number of classes being taken, and the third holds the numb...
answer(10) view(850) status()
)
Database design before starting
Hi, I would appreciate any help or suggesions on starting with database design for an asp.net site. I know this question maybe sounds silly but I feel stuck and don't know where to start. Yours sincerely Andla
Hi, I would appreciate any help or suggesions on starting with database design for an asp.net site. I know this question maybe sounds silly but I feel stuck and don't know where to start. Yours sincerely Andla
answer(2) view(723) status()
)
I'm in a DB class and having trouble with SQL*Plus on win ME
Yes, I know, ME is not all that great but it will do for now! A software set called Oracle 9i Development Suite for Win XP, 2000, or NT came with my book for class. I have installed it on my desktop PC which has win XP. It installed without...
Yes, I know, ME is not all that great but it will do for now! A software set called Oracle 9i Development Suite for Win XP, 2000, or NT came with my book for class. I have installed it on my desktop PC which has win XP. It installed without...
answer(0) view(939) status()
)
Calculating fine due
Hi, i need to calculate the fine due for a book system. I have a date that the book needs to be back and a date of when the book was actually returned, and then a fine field. if the book is over 7 days late, it is ?.30, if the book is over ...
Hi, i need to calculate the fine due for a book system. I have a date that the book needs to be back and a date of when the book was actually returned, and then a fine field. if the book is over 7 days late, it is ?.30, if the book is over ...
answer(1) view(816) status()
)
date query not working
Hello All. I am trying to return data based on a variable set to yesterday's date. I saw another post that was similar but it was for access. Not sure if SQL server 2000 works the same. My code is below: thisDate = FormatDateTime(N...
Hello All. I am trying to return data based on a variable set to yesterday's date. I saw another post that was similar but it was for access. Not sure if SQL server 2000 works the same. My code is below: thisDate = FormatDateTime(N...
answer(3) view(871) status()
)
Using zulu/UTC in SQL
I'm trying to generate an automatic timestamp on data passed to my SQL server. I specifically need the timestamp to generate a zulu or UTC entry. What is the best way to accomplish this? So far I've had no luck.
I'm trying to generate an automatic timestamp on data passed to my SQL server. I specifically need the timestamp to generate a zulu or UTC entry. What is the best way to accomplish this? So far I've had no luck.
answer(2) view(199) status()
)
Yahoo style directory
Hi. I'm trying to write a directory like Yahoo in ASP using an Access database. I have three tables: Companies - Contains all information about each company including a number which represents which catagory it is in. Catagory Listing - ...
Hi. I'm trying to write a directory like Yahoo in ASP using an Access database. I have three tables: Companies - Contains all information about each company including a number which represents which catagory it is in. Catagory Listing - ...
answer(4) view(76) status()
)
Need help with SQL
I have been programming for a long time, but I am a relative newbie with SQL. I have two tables with transactions. One table contains ALL transactions, the second table is a subset of the first with only a specific set of transactions. T...
I have been programming for a long time, but I am a relative newbie with SQL. I have two tables with transactions. One table contains ALL transactions, the second table is a subset of the first with only a specific set of transactions. T...
answer(2) view(783) status()
)
Dropdown adding to list (text field)
Hello Right. I'm designing a literature request page. There are 4 catergories of literature. Each with seperate items in each. I want users to be able to request quanities of item/s ergo. 1 Red Pack, 9 Green Packs in one request ...
Hello Right. I'm designing a literature request page. There are 4 catergories of literature. Each with seperate items in each. I want users to be able to request quanities of item/s ergo. 1 Red Pack, 9 Green Packs in one request ...
answer(1) view(702) status()
)
Error 80040e14
Really stuck on this update. Code that changes is in SET. Using Access 2000. Anyone know why this code works: cmdUpdate.CommandText = "UPDATE DateAvailable SET EnquiryID = 123 WHERE BookingDate >= #" + Replace(DoDate...
Really stuck on this update. Code that changes is in SET. Using Access 2000. Anyone know why this code works: cmdUpdate.CommandText = "UPDATE DateAvailable SET EnquiryID = 123 WHERE BookingDate >= #" + Replace(DoDate...
answer(10) view(16) status()
)
Tricky SQL Query
Thank you in advance for any help! I have two tables, TblPNBooking and TblShipping . They are in a one to many relationship on a field uniquePNID. TblPNBooking uniquePNID can have many shipments. When the query is run I need the results ...
Thank you in advance for any help! I have two tables, TblPNBooking and TblShipping . They are in a one to many relationship on a field uniquePNID. TblPNBooking uniquePNID can have many shipments. When the query is run I need the results ...
answer(4) view(106) status()
)
linking a form to database
Hey! I'm trying to link the responses from a survey to my pre-existing MS ACCESS database. The survey consists of radio buttons, checkboxes, and a couple of text boxes. I would like for each checkbox to be read in seperately. Currently, if ...
Hey! I'm trying to link the responses from a survey to my pre-existing MS ACCESS database. The survey consists of radio buttons, checkboxes, and a couple of text boxes. I would like for each checkbox to be read in seperately. Currently, if ...
answer(1) view(646) status()
)
Deleteing records with related tables
Hello once again. I seem to be getting this annoying error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The record cannot be deleted or changed because table 'tblMovi...
Hello once again. I seem to be getting this annoying error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The record cannot be deleted or changed because table 'tblMovi...
answer(1) view(598) status()
)
SQL String will not work in ASP.NET!!
Hi! I have some problems with this SQL string in ASP.NET: It works fine with Access 2002: sql = _ " select avg(cdbl(iif(resultat is null,0,resultat))/cdbl(iif(serier is null,1,serier))) as snitt ," & _ " s.namn, &q...
Hi! I have some problems with this SQL string in ASP.NET: It works fine with Access 2002: sql = _ " select avg(cdbl(iif(resultat is null,0,resultat))/cdbl(iif(serier is null,1,serier))) as snitt ," & _ " s.namn, &q...
answer(6) view(696) status()
)
insert problem in oracle
Hi everyone!! I am doing a project using designer 6i and web pl/sql,I am facing few problem as I have written a procedure which in a for loop calls another procedure to insert into a table,I am trying to insert two fields into a table but...
Hi everyone!! I am doing a project using designer 6i and web pl/sql,I am facing few problem as I have written a procedure which in a for loop calls another procedure to insert into a table,I am trying to insert two fields into a table but...
answer(0) view(9) status()
)
Cant add more than one word to database record
My page takes inputted text from the user and adds it to a record in the database. Only the first word is added to the field if more words are entered. The field type is nvarchar so I dont understand why it wont capture the rest of the text...
My page takes inputted text from the user and adds it to a record in the database. Only the first word is added to the field if more words are entered. The field type is nvarchar so I dont understand why it wont capture the rest of the text...
answer(5) view(320) status()
)
I need help structuring an UPDATE statement with multiple joins
Okay I have an application where I need to replace a variable in one data table with the value from another data table. Problem is there are two table in between that relates the records and I canę° figure out how to structure the update sta...
Okay I have an application where I need to replace a variable in one data table with the value from another data table. Problem is there are two table in between that relates the records and I canę° figure out how to structure the update sta...
answer(0) view(41) status()
)
SQL statement help with joins
I have a massive database that I inherited so Im still having some trouble getting around it. I have 4 sql statements that I need to merge into one. I have a sql statement that is the basis for a report in MS Access (the tables are all ...
I have a massive database that I inherited so Im still having some trouble getting around it. I have 4 sql statements that I need to merge into one. I have a sql statement that is the basis for a report in MS Access (the tables are all ...
answer(0) view(66) status()
)
Data type mismatch in criteria expression.
Hi. I am trying to make a page where you can view orders which customers have placed, I have already made several of these pages, however they were viewing the customers and products. The problem ii have is that i have made a dynamic drop ...
Hi. I am trying to make a page where you can view orders which customers have placed, I have already made several of these pages, however they were viewing the customers and products. The problem ii have is that i have made a dynamic drop ...
answer(5) view(659) status()
)
Unclosed Database Sessions and aspx
<i><b>Originally posted by : Edi (edid@agur.co.il)</b></i><br />We work with OracleClient and SQLClien connections and Asp.Net. IIS not close SQL Server and Oracle Session connections. This sessions closed only...
<i><b>Originally posted by : Edi (edid@agur.co.il)</b></i><br />We work with OracleClient and SQLClien connections and Asp.Net. IIS not close SQL Server and Oracle Session connections. This sessions closed only...
answer(1) view(798) status()
)
How do I insert an integer variable into an INSERT
I get the following error upon executing an INSERT. (I am using vb.net) The name 'x' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. . My code looks like: dim x a...
I get the following error upon executing an INSERT. (I am using vb.net) The name 'x' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. . My code looks like: dim x a...
answer(2) view(218) status()
)
Retrieve other values while using Min and Max aggregates
Hi all. I tried to search the forum for this, but I'm not entirely sure how to phrase it to get the best results, so I figured I'd post and hope someone can help me out. I've got a SQL statment that retrieves the minimum and maximum valu...
Hi all. I tried to search the forum for this, but I'm not entirely sure how to phrase it to get the best results, so I figured I'd post and hope someone can help me out. I've got a SQL statment that retrieves the minimum and maximum valu...
answer(2) view(91) status()
)
Date related question
Hi all, Just a quick question. I'm trying to do a select statement that takes all records that have been created in my MS Access database within the last 3 days, but I'm having a few problems. I've done SQL statements using dates before, ...
Hi all, Just a quick question. I'm trying to do a select statement that takes all records that have been created in my MS Access database within the last 3 days, but I'm having a few problems. I've done SQL statements using dates before, ...
answer(3) view(972) status()
)
Programming
Related Pages
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2008 by Infoqu. All rights reserved
Copyright 2007-2008 by Infoqu. All rights reserved