Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF MYSQL


Query for matching 2 subtrings  

HI, I have to write a query in which I have 2 tables and both tables have few same column name. Example: Table 1 has following colums:id,sell,key,actionTable 2:id,buy,key,actionNow, 'Key' column has values like... Continue Reading
Views : 153
Tuesday 27th of November 2012

Another 80040e14 error  

Getting: "Microsoft OLE DB Provider for ODBC Drivers error '80040e14'" at the Line:Select * FROM Workshop ORDER BY ID_Workshop WHERE Workshop_Evaluator = 15I know the problem. It's the number for the Workshop_Evaluator as that number does not exist. But I cannot... Continue Reading
Views : 77
Tuesday 27th of November 2012

Sql stored procedure  

Hi,I have to sent out emails to users if they exist in a tableI have a propertyid value that I will sent to the stored procedureIf the propertyid exists in the table i want to return adminidThen I get that adminid and I want to get the email address of... Continue Reading
Views : 103
Tuesday 27th of November 2012

Stuck at first positive entry  

Hi,I have a small test table with a column called animal and a column called coat. The coat type hair appears twice, at the second and sixth entries (horse and giraffe).I cannot get my code to return both values. It stalls the first time the sql is satisfied. Here are the relevant... Continue Reading
Views : 55
Tuesday 27th of November 2012

Fifo  

I can't wrap my head around this one, maybe someone else can.I have a table with purchases of stock. similar to this.TranID |StockID | Date |Qty | Price 1000 |1234 | 12/20/210 | 20 |1.95 1200 |1234 | 1/10/2011 | 50 | 2.00 1345... Continue Reading
Views : 54
Tuesday 27th of November 2012

SQL Multiple Choice  

Hello!I am trying to create a multiple choice test which will be available online soon, hopefully. The problem I am having is working out how I can use SQL to build the test, so the result of the test is added up and shown at the end of the test, the test taker can see their answers... Continue Reading
Views : 57
Tuesday 27th of November 2012

Study materials for 1Z0-058  

Is there anyone who passed Oracle 1Z0-058 test?any tips to study for it?can you suggest me where can i get the study materials?Thanks in advance! Continue Reading
Views : 102
Tuesday 27th of November 2012

Formatting an SQL select  

Hi, I am trying to format the SQL query i have below in order to have the CoLocalCount show up with '# of Locals:' in front of the actual Count itself. I have changed to count to varchar in order for it to be able to read text but no matter where i put the actual 'quotes' it errors out. Any... Continue Reading
Views : 62
Tuesday 27th of November 2012

sdfg  

Originally posted by : sdfg (sdfg)sdfg Continue Reading
Views : 53
Monday 26th of November 2012

ODBC Timeout in ADO to SQL Server  

Originally posted by : Bryan Avery (b_avery@yahoo.com)I would like to increase my ODBC timeout from ADO to SQL Server.Where in the code do I do this? Continue Reading
Views : 56
Monday 26th of November 2012

Help with SELECT LIKE, variables, and wildcards  

Originally posted by : J.R. Porter (jar@nauticom.net)Is it possible to put a variable into an SQL query in ASP? Suppose I have the following...SELECT * FROM Archive WHERE lname LIKE 'C%'This would get every last name that started with the letter C.... Continue Reading
Views : 57
Monday 26th of November 2012

enterprise manager  

Originally posted by : chris (chrisr@cisteam.com)does any one know if you can register a server over the web Continue Reading
Views : 73
Monday 26th of November 2012

How to sort by date  

Originally posted by : Martin Johansson (info@sd-studios.com)How to sort by date when displaying database records? Continue Reading
Views : 56
Monday 26th of November 2012

Defining Creation Date for Records-Access 97  

Originally posted by : Steve H (samiz@msn.com)I need define a table field with the creation date for a new record. It's for a form that users will fill out on our web site. When the form is submitted, the user's information will be written to a new record in the database. I... Continue Reading
Views : 46
Monday 26th of November 2012

sinqle quotes in SQL statements  

Originally posted by : PCalabria (PCalabria@pcenterprises.com)I'm trying to update a character field in my access database with a string that contains a sinqle quote. VB sript doesn't mind the quote at all, strBookList="Pat's", but when I try to add the line to an SQL... Continue Reading
Views : 105
Monday 26th of November 2012

Export to Excel without ActiveX  

Originally posted by : KirHow can I send data from my SQL DB to Excel file format in ie ? Continue Reading
Views : 124
Monday 26th of November 2012

Problem with stored procedure using OLEDB  

Originally posted by : Lynn (Lynnkuo2000@yahoo.com)I have problem of using OLEDB for calling any stored procedure which has any update or insert statement and then return with select statement, but with the same stored procedure using DSN then it's okay. This is... Continue Reading
Views : 68
Monday 26th of November 2012

Problem with Update  

Originally posted by : ade (adrian@dublin.com)I'm getting a sytax error when i try to update using the following code.Any Ideas Continue Reading
Views : 100
Monday 26th of November 2012

CONVERT function  

Originally posted by : Mel (meldrape@texas.net)Greetings,I am receiving the following error:Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit Continue Reading
Views : 81
Monday 26th of November 2012

simple problem/fix  

Originally posted by : Curtis (eludz@hotmail.com)please help me with this simple test code that doesn't seem to work for some reason.. I bought the book active server pages 2.0 and I'm trying to use the logic but it doesn't seem to be working.. and I don't really want to use... Continue Reading
Views : 68
Monday 26th of November 2012

ASP incorrectly displays SQL NUMERIC 6,3 field  

Originally posted by : Allan (aspielma@yahoo.com)I am using a ASP recordset to access data from SYBASE SQL.There is a SYBASE SQL table with certain numeric fields defined as NUMERIC 6,3I use a stored procedure to retrieve certain rows and another one... Continue Reading
Views : 74
Monday 26th of November 2012

Connection error  

Originally posted by : Doug Seven (doug.seven@codejunkies.net)Generally this means there is probably a typo in the SQL Statement. Basically, your data provider can not find one of the columns or tables you specified. My experience (I teach this stuff, and students... Continue Reading
Views : 77
Monday 26th of November 2012

SQL Questions  

Originally posted by : Robert Megliorino (rmeglior@alleghenytechnologies.com)Hello: I'm trying to do two things:1) How can I have a text field with more than 255 characters? I tried memo, but the ASP component returns an error when I select it. I also... Continue Reading
Views : 104
Monday 26th of November 2012

SQL - types of fields  

Originally posted by : Jeff (sipek.jeff@post.cz)Can somebody write me a list of all types of fields in sql? I know that there are Integer, and Varchar and that's it.Please mail me.Thank you in advance Continue Reading
Views : 69
Monday 26th of November 2012

displaying text files without using include file  

Originally posted by : cem tekin (tekin65@yahoo.com)hi, i'm quite new to asp. i wonder if there's anybody who do have an answer to my problem.i'm trying to insert one of many text files into a page based on the choice of the visitor. the names of the text files... Continue Reading
Views : 72
Monday 26th of November 2012

Combo box sets up Second Combo box  

Originally posted by : Keith Malatesta (Malatesta@mediaone.net)Thank you all for helping me with my Update problem... I have another one. I am trying to set up two combo boxes where the first Displays Distinct from ProductCategory.ProductCategory. I want the... Continue Reading
Views : 64
Monday 26th of November 2012

I would like to use a common used id as a primary key for several pages  

Originally posted by : Pingh (pingh@m-ei.com)Hellocurrent;y this is my situationi have one page main.asp that collects user data, and then submits it to a database. I would like i then to transer one field called USERID to another page... Continue Reading
Views : 100
Monday 26th of November 2012

how to connect excel database using asp  

Originally posted by : sangeeta (life01_01@yahoo.com)I have some information in the format of excel file and I want to reterive that information, in a form using asp and html Continue Reading
Views : 70
Monday 26th of November 2012

Converting MDB into text !!!!!!!!!!  

Originally posted by : Vishal Gupta (vishalg@graceworks.com)hi friendsi am finding problem in making a COM to convert an entire database(MS-ACCESS) into a single text file and vice versa.can u please tell me how to go about?thank youregards Continue Reading
Views : 93
Monday 26th of November 2012

SQLOLEDB and distributed transactions  

Originally posted by : Jignesh (codehunt@yahoo.com)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 network utility and enterprise manager->security->Linked Servers. I am able to run... Continue Reading
Views : 53
Monday 26th of November 2012