Fenerbahce

[COLOR=#008000]command.Parameters.AddWithValue("@number", TextBox1.Text) can i do this from another way? [/COLOR]

hi, i receive an error on this line -- if (salesPersonsName <! "end") -- error : operator ! cannot be applied to java.lang.String what can i do? thanks

I choose something from selectbox and click on the button and i get list of the data from database but, whatever i choose from selectbox doesn't remain what i have chosen. It sets itself to first value. How can i do "selected" ? [code] <?php $mysqli = new mysqli("localhost","root","","inantest"); if …

Hi, This code works fine but, when i choose "Female" from selectbox, it sets "Male" in the selectbox again. What is the problem? Thanks [code] <?php if (!isset($_POST["sex"])) { print "Please start!"; } else if ("Male" == $_POST["sex"]) { print "Male !"; } else if ("Female" == $_POST["sex"]) { print …

Hi, I want to call a stored procedure for the below php code. How can i create a stored procedure and call it for below program instead. Mysql please. Thanks. [code] $comboSecenek=$_POST["ComboBox"]; $adet=$_POST["adet"]; $sql = "UPDATE product SET amount = amount + '$adet' WHERE name = '$comboSecenek'"; [/code]

Hi, When i add new product into "Products" table, a trigger will add a record into "stocks" table. Example; stock=10,productId=99 How can i do that? Thanks [code=sql]CREATE TABLE products( productId INT(10) NOT NULL AUTO_INCREMENT, productName VARCHAR(10), PRIMARY KEY (productId)); CREATE TABLE stocks( stock INT(10), productId INT(10), FOREIGN KEY (productId) REFERENCES …

Hi, I can create all tables but order table. What is wrong, is it foreign key? [code=sql]CREATE TABLE customer( customerId INT(10) NOT NULL AUTO_INCREMENT, customerName VARCHAR(10), customerSurname VARCHAR(10), customerAddress VARCHAR(10), PRIMARY KEY (customerId)); CREATE TABLE order( orderId INT(10) NOT NULL AUTO_INCREMENT, customerId INT(10), PRIMARY KEY (orderId), FOREIGN KEY (customerId) REFERENCES …

Hi, I want to create a table in Mysql but i receive an error. [COLOR="Red"]Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\wamp\www\CreateTable\create.php on line 11 Table veriler_2 couldn't been created! : [/COLOR] i give you the whole lines to check it for me. I can not …

i installed sokkit on my windows xp but the localhost s nt working. when i installed the same sokkit on another system with xp then localhost s openin very well. what can be d prob

Hi, I use wampserver (or vertrogo serv) and installed in c:\wamp. I have a file called test.php in c:\wamp\www\test.php. When type [url]http://localhost[/url] into browser, it asks me password and username. I cant just pass that. Therefore, i cant use anything. Where this password and username thing come from? I didn't …

Query = "select * from table2 where number='" + Text5.Text + "'" Rs.Open (Query), Conn, adOpenStatic, adLockReadOnly Hi, If "number" is defined as Auto number in Access database, second line generates an error. If "number" is not defined as Auto number then, no problem. What can i do? Thanks

Hi, I use VB6 with Access. I have 4 records in my DBF file. When i do Recordcount, it says that i had -1 record. Why not 4? Help please Thanks Dim Conn As New ADODB.Connection Dim Rs As New ADODB.Recordset Dim Query As String Private Sub Form_Load() Conn.ConnectionString = …

Hi, I am using VB6. I use Datagrid to list my data from a Dbf file. When i click on a row of Datagrid, it doesn't trabsfer actual data into Textboxes. It transfers previous clicked data into textboxes. What can i do? Private Sub DataGrid1_Click() Text3.Text = Adodc1.Recordset("Number") Text4.Text = …

Hi, When i press "end" button on keyboard, i want to see "pressed on end button" message on screen. How can i do this. I am new in Java. Thanks

Hi, i have 2 tables. i have 3 equal colomns in both. I want transfer all data from 1st table to another one. How can i do it? Thanks this doesn't work but something like this; insert into exam (e_score, l_name, s_id) values (dbo.assignment.e_score, dbo.assignment.l_name, dbo.assignment.s_id)

HI, [COLOR=#000000]I am trying to return automatic value into another column with using trigger in a table, when I enter new record into that table. It works if it is first data to be in that table. If I have more than one record already, it doesn’t work. I thing …

Hi, SELECT * FROM veriler WHERE (name LIKE '%in%') This line doesn't work in Ms Access, IN either. No error is given is well. But It works in SQL server. How can i do in Access? Thanks

I need help in setting up a connection string from MS Access to Pervasive SQL.:rolleyes:

table : kisiler name surname points ----- -------- ---- ali elli 1 ali elli 5 ali elli 5 veli kollu 3 veli kollu 4 adem bacakli 2 ali elli 4 veli kollu 5 Q ; how can i get result has been showed below; ali elli 15 veli kollu 12 …

Hi, I have a website. I want to put a searchbox and search what i want to find in content of my website not in database file. How can i do this? Thanks

hi, table : kisiler name surname points ----- -------- ---- ali elli 1 ali elli 5 ali elli 5 veli kollu 3 veli kollu 4 adem bacakli 2 ali elli 4 how can i get reqult which has been shown below ? MAX value ali elli 5 ali elli 5 …

Hi, how can i display images in a form in Ms Access 2003. I have fields in a table and path of images. Thanks

hi, 1-how can i do multiselect in calendar. 2-how many days between 2 dates? how can u calculate it? example : 10/10/2006 - 12/10/2006 there is 1 day between those 2 dates. thanks

hi, 1-how can i do multiselect in calendar. 2-how many days between 2 dates? how can u calculate it? example : 10/10/2006 - 12/10/2006 there is 1 day between those 2 dates. thanks

Hi, When i click on a Button, i want it to search in database what string or integer Textbox has in it, and list that into datagridview. Thanks. VB.NET please

hi, how can i find out that what number of record(row) my cursor focused on in database? thanks label1.text= active row`s number ????? example : [COLOR=#0000ff]Dim[/COLOR][COLOR=#000000] baglanti [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#000000] [/COLOR][COLOR=#0000ff]New[/COLOR][COLOR=#000000] SqlClient.SqlConnection()[/COLOR] [COLOR=#0000ff]Dim[/COLOR] command [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] SqlClient.SqlCommand() [COLOR=#0000ff]Dim[/COLOR] kisiler [COLOR=#0000ff]As[/COLOR] SqlClient.SqlDataReader [COLOR=#0000ff] [/COLOR]baglanti.ConnectionString = [COLOR=#800000]"data source=instance2000;"[/COLOR] & [COLOR=#800000]"initial catalog=dbf;"[/COLOR] & [COLOR=#800000]"integrated security= …

I spent my whole day but I could not solve the problem. I dont have much experience in Asp.net. Please help... DropDownList dont send selected value to the Sub DropDown_SelectedIndexChanged The Error Message is:[B]Exception Details: [/B]System.NullReferenceException: Object reference not set to an instance of an object.[B] [/B][B]Source Error:[/B] Line 38: …

hi, iam having 2 listboxes.In one listbox i am populating products from Msacess.Then after clicking any of the product it should populate corresponding schedules in the other listbox.Below is my code Kindly reply me as soon as possible.. [CODE] [COLOR=#0000ff]Dim[/COLOR][COLOR=#000000] sql [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#000000] [/COLOR][COLOR=#0000ff]String [/COLOR]con = [COLOR=#0000ff]New[/COLOR] OleDbConnection("Provider=Microsoft.jet.oledb.4.0;Data Source=D:\Inetpub\wwwroot\WebApplication12\WRMdatabase.mdb") sql = …

hi, how can i find out that what number of record(row) my cursor focused on in database? thanks label1.text= active row`s number ????? example : [code] [COLOR=#0000ff]Dim[/COLOR][COLOR=#000000] baglanti [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#0000ff]New[/COLOR][COLOR=#000000] SqlClient.SqlConnection()[/COLOR] [COLOR=#0000ff]Dim[/COLOR] command [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] SqlClient.SqlCommand() [COLOR=#0000ff]Dim[/COLOR] kisiler [COLOR=#0000ff]As[/COLOR] SqlClient.SqlDataReader baglanti.ConnectionString = [COLOR=#800000]"data source=instance2000;"[/COLOR] & [COLOR=#800000]"initial catalog=dbf;"[/COLOR] & [COLOR=#800000]"integrated security= SSPI" …

I'm a newbie and I've got some problem with my project. Here's my prob. I have 2 pages. First page I have 2 dropdownlist, months and years, and some radio button. Second page I have checkboxlist and submit button. When i click on radio button in the first page(autopostback), it …