Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF MYSQL


How To Send And Receive Fax On PC...!!  

Originally posted by : Varun Vij (getvarun2001@yahoo.com)Hi GuysCan anyone tell me that how to send and receive fax on pc by using internet....thanxsvarun Continue Reading
Views : 54
Monday 26th of November 2012

showing 25 rows of a table in each page  

Originally posted by : yaron (yaron_kh@yahoo.com)helloi'm trying to show 25 rows of a table in a one page and with the NEXT button show the next 25 rows and so on.what is a good way (minimal use of resources)to do that?i don't... Continue Reading
Views : 66
Monday 26th of November 2012

asp.net and Ms Access  

Originally posted by : ajr (arunjustin@rediffmail.com)Is it posible to connect Ms Access with asp.net i tried with Dsn ,it is not exceptingcan any one give me suggestin for itThanking you,ajr Continue Reading
Views : 75
Monday 26th of November 2012

SQL Syntax for search MSAccess Database from a html dropdown FORM page using ASP  

Originally posted by : Sudip (sudip@css.cmmacs.ernet.in)what is the sql syntax for the query likeselect field (from a dropdown menu of 4 fields, select name=A) put query (text box name=b)and select one boolean operator(name=C)and select other field (from same type of... Continue Reading
Views : 85
Monday 26th of November 2012

Connection to a mdb on a server other than the web server  

Originally posted by : Jeff (JWindsor@suncor.com)I am trying to access a mdb file that is on a server different than my web server. I created a share and put the UNC to the file on the server_path but I get an access denied error. I mapped a drive and got the same... Continue Reading
Views : 64
Monday 26th of November 2012

ADODB.Field-Fehler '80020009'  

Originally posted by : Kastlaz (marco.ribi@gmx.ch)What's my problem ??? I became every time the same message (ADODB.Field-Fehler '80020009')Please help me ?Thank you & Greez Continue Reading
Views : 114
Monday 26th of November 2012

about datagrid.columns.headertext(had source code)  

Originally posted by : GuoYong (chenggy@163.net)Source codeDim strsql As Stringstrsql = System.Configuration.ConfigurationSettings.AppSett ings("server")Dim cn As New OleDbConnection(strsql)cn.Open()strsql = "select... Continue Reading
Views : 59
Monday 26th of November 2012

Printerfriendly version  

Originally posted by : Tore (webmaster@lufs.no)I have a database-driven news-function on my site (haven't written it myself, only moderated it), that allows me to publish news through an admin-page. Now I want to add a function that puts the news into a printerfriendly page.... Continue Reading
Views : 52
Monday 26th of November 2012

Uses ASP with Oracle.  

Originally posted by : Cleber Ramos da Silva (cleberamos@globo.com)Help!I need to create code in ASP using SQL-Oracle,Is this possible? How ?Please,sorry, my english isn?t perfect.I Wait answer.Thanks atencion Continue Reading
Views : 35
Monday 26th of November 2012

editing datagrid  

Originally posted by : Karin Vanderheide (kvdheide@godutch.com)Hello I seem to be having problems using the OnUpdateCommand and OnCancelCommand in my datagrid: can anyone see where my error is?When I use the edit button... the boundcolumn turn to textboxes and I... Continue Reading
Views : 69
Monday 26th of November 2012

abt trigger  

Originally posted by : Nitesh (friend_nitesh@rediffmail.com)how can i update a triggerorhow can i view name of all trigger created by me Continue Reading
Views : 62
Monday 26th of November 2012

query problem  

Hi When I give queryselect * from table where bannerid='"&bannerid&"' and visitordate between '1/1/2003' and '1/26/2003'it displays results between the given periodbut when i give queryselect * from table where bannerid='"&bannerid&"' and visitordate... Continue Reading
Views : 52
Monday 26th of November 2012

Running stored proc from web w/o waiting to cmplte  

I have a SQL stored procedure which runs for a good 25 minutes or so. I need to find a way to fire off the stored procedure without waiting for it to complete. I takes longer to run than our application timeout settings. Is this possible? Continue Reading
Views : 41
Monday 26th of November 2012

new project yes/no auto-toggle news display  

Where to begin?I have a login page using table1.userid, with a field called fldnews.fldnews is a yes/no field. I need to always set this field to no when a user logs in.But, If "I" have it set to yes when a user logs in I'm wanting to display a news.txt using asp and... Continue Reading
Views : 39
Monday 26th of November 2012

Incorrect syntax near (ASP.NET)  

This snipts works fine with OLEDB and MS Access database but in SQL Server mode gives: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near ')'. Public Sub bindArchive() Dim sqlConn As New... Continue Reading
Views : 103
Monday 26th of November 2012

To add date in mysql database  

Hi , I have an asp page which is used to add a record to the database.When adding it to the database it shud add the date of the day without entering it.I could achieve this in MSAccess but im not able to do it in mysql.In MSAccess i just add the Now() function. Continue Reading
Views : 57
Monday 26th of November 2012

how to conver access into sql  

Hello to everyone I'm new and i'm happy that i have found this.I had a question which might have been asked many times: how do I convert access codes into sql?I have this data base in access which needs to be in sql . I wanted to know if i have to write codes or something... Continue Reading
Views : 256
Monday 26th of November 2012

only one oledbConnection throughout application  

Originally posted by : ashish (tamhane_ashish@rediffmail.com)i am developing on line tutorial in ASP.NETi have my database in Microsoft ACCESS(.MDB)iwant to create only one instance of oleDbConnection object. and use it throught out my Web application(from... Continue Reading
Views : 61
Monday 26th of November 2012

r.GetSchemaTable  

Originally posted by : jeorg (jeorg@inbox.as)I cannot get the columns names without doing a select before and then aDim drc As DataRowCollection = r.GetSchemaTable().Rowsdoes someone knows if it is possible something like Continue Reading
Views : 45
Monday 26th of November 2012

rstSearch.RecordCount works but get no records returned in table  

Originally posted by : Lee Farrant (leefarrant@hotmail.com)below is some sample code which I have added to. Since I changed from a dsnless to a DSN connection I am having some problems. the count of records get displayed in my webpages fine so the RecordCount... Continue Reading
Views : 53
Monday 26th of November 2012

how to cut short a string  

Originally posted by : kamp (kamph@netease.com)the string saved by MSSQLserver will has some zeros at it's tail. After i get the string from MSSQLserver, how to cut it into exactly what it is? (i use c#) 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 : 63
Monday 26th of November 2012

DB Locking  

Originally posted by : Ramanathan (plrams@yahoo.com)If i have multiple users trying to insert into my MSAccess database at the same time, with the single asp code, and i have a table lock on, will the inserts be queued or will they return errors. Continue Reading
Views : 41
Monday 26th of November 2012

Database not being updated  

I am using the following asp code to update an existing record in a database, but the database is not being updated. I am not receiving any errors.ASP:'create and open the database obj Set objConn = server.createobject("ADODB.Connection") objConn.Open... Continue Reading
Views : 76
Monday 26th of November 2012

Dynamic listbox/jump trouble  

I am trying to build a dynamic listbox that will load a page when the user selects something. The url that I want to load is competitors.asp?company= and the company that they selected would be part of the querystring. I have gotten the listbox to dynamically load live data, but cannot get it... Continue Reading
Views : 40
Monday 26th of November 2012

How to connect to Linux Based MySQL using ASP  

Hi, I want to connect MySQL database which is there in Linux machine, using ASP page where i want to perform all the data manipulation actions using the ASP page. Provide me a solution. If any body gives me a sample code that would be fine as i am fresh to ASP coding. Continue Reading
Views : 45
Monday 26th of November 2012

Trying to make a select statement conditional  

I am writing a SQL trigger that inserts a line into a table and I want to say that IF "?7856?" = "Regular" then insert this select statement or IF it says "COMPOUND" then do this select statement. I already have an UPDATE and ANOTHER INSERT STATEMENT RUNNING BEFORE THIS ONE. Continue Reading
Views : 49
Monday 26th of November 2012

SQL statement to retrieve last two rows  

Hey everyone!I am writing a program in vb.net !Using an oledbdataadapter i generate a dataset and display dataset records in a datagridThe user will be able to add new records to this datagrid which will update the database(access) upon the click on the update... Continue Reading
Views : 93
Monday 26th of November 2012

Matisse, the Post-Relational SQL Database  

Matisse (www.matisse.com), the ultimate database for .NET and Java, is an innovative Post-Relational SQL database for .NET and Java environments that natively supports Objects and XML. The Matisse database represents an... Continue Reading
Views : 37
Monday 26th of November 2012

SQL Data Types - Please Help  

I have a search page that has several options to search a SQL Server 2000 database. The text box is the string, radio buttons to decide which field to search by.. Code: Continue Reading
Views : 62
Monday 26th of November 2012