how to find max values using MySQL as the database? examples in the database ID (primary key and AutoNumber) data that will come 12. so, in the form at the moment want to add data, automatic number 12 also
View 1 RepliesMySQL databases exists for saving values as strings (text only). Is there any way that i could store files with the same speed as a mysql command ? I know that it depends on the file size but lets say that the file is "Avatar.jpg" 50KB... I ve tried FTP but this is not what im looking for. e.g. You want your users been able to upload a file like the [Add This Attachment] button does in dreamincode.net and you dont have any background on PHP/HTML/Javascript/ASP.NET just VB.NET and the basics of MySQL plus you dont want to use it for a website. How do you accomplish this? Something silly that ive tried was opening an image as text then update the mysql server with that text but it didnt work backwards after i wrote the text on the file and oppened it ...it said that the image was corrupted.
View 7 RepliesI am using Visual Basic express edition 2008.I am trying to know if a value in a single dimensional array is repeated in the array. If yes, then multiply one of them by 100. For example:
MyArray (14) = 12, 15, 18, 15, 18, 11, 15, 18, 16, 14, 18, 8, 12, 17, 10
In the above example:
MyArray (1) = MyArray (3) = MyArray (6) = 15
MyArray (2) = MyArray (4) = MyArray (7) = MyArray (10) = 18
MyArray (0) = MyArray (12) = 12
[Code]...
I have a two different tables, Table 1 and table 2.
Table 1
-----------
Resource
Start Date
End date
[Code]....
Here I have to match the total hours of each table according to the resource,
then have to find the mismatched data and find difference with that values of mismatched data.
i installed Mysql Connecter Net 5.2.5... but i cant't find it in Data base Explorer
View 15 RepliesI am creating a database project where I take my data from mysql database and then create graphs and charts.I currently have microsoft visual basic 2010 express edition. I am familiar with visual basic but have never used mysql before. I have quried a database into mysql and server connection to the database is working fine. Furthermore I downloaded mysql a week ago so I have the latest connector.I looked at many youtube tutorials and have tried to find mysql.data in the add reference section (in project) but it doesn't seem to be
there.
I'm trying to add values to a MySQL database. The values that I need to save come from several textboxes. The SQL-query is read from a XML-file.
Query: INSERT INTO myTableName(ID, Groep, Naam, Achternaam, Intern, etc...) VALUES(NULL, NULL, tel_txt_group.Text, tel_txt_name.Text, tel_txt_surname.Text, tel_txt_intern.Text, etc...)
Unknown column 'tel_txt_group.Text.ToString' in 'field list'
[code]...Find last rows each machine_id in mysql database with program?
View 1 RepliesI'm trying to insert values from my asp.net application into my MySQL database.
On the register page people can fill in Name and Pass and press submit.
Public Function InsertMember(ByVal objMember As Member) As Boolean
[Code]...
I figured it out without useing parameters, but that error message tip did help me figure it out. Ok so ive been trying to just insert a string into a MySQL database, heres the code for it its very simple. Its just not working need help to get this to work before i can move on textboxes. I get the cannot connect erroer each time i do it.
[Code]...
Trying to do a mysql parametrized query and i'm having a little issue.
cmd = conn.CreateCommand
cmd.CommandText = "insert into `rootforest` (rootforestname, BusinessName) VALUES (?rfname, ?bname)"
[Code]....
It errors on the executenonquery. Says the column rootforestname can not be null. i don't under stand why it does not fill in the value in the command text.
I am getting this error in MySQL on search for keywords. The error: Can't find FULLTEXT index matching the column list. My Database Table is a MyISAM and my dataTypes I am searching are Text. Any Ideas why I would get the above error?
View 6 RepliesSo I am able to get the comboBox populated with the proper list of "clientLocations".
However they all have a valueMember of 0; thus the issue at hand is properly assigning the value of the comboBox items to the database column (which is returned in the dataset) rather than just the name.
Private Sub updateClientLocationComboBox()
'clear list
comboBox_clientLocations_deviceList.Items.Clear()
[Code].....
I am using vb.net with phpMyAdmin MySql database. While running the piece of code below, the program hangs in the for loop before the variables are assigned values from the data table(dt)...
'Check for appraisal period-----------------------------------------------------------------------
Dim sqlCheckDate As String = "SELECT * FROM tblappraisalsetting where appSetID=(select max(appSetID) from tblappraisalsetting);"
[CODE]................
I'm building a program to read a text file and display and find the min and max values within the textfile and display them in text boxes (txtMac, TxtMin) for the user. The program also needs to count the number of items in the text file and put the number in a textbox called count.
So far i've made the code to find the max value (below) but have no idea how to get min value and count.
[Code]...
I have this dictoinary:
Dim chardict As Dictionary(Of Char, Integer) = Nothing
chardict.Add("A", 0)
chardict.Add("B", 1)
I wanted to do the following if statement but I am a bit stuck on the syntax:
if chardict.containskey("A")
'display the value that corrosponds to the letter "A"
'in this case display the character 0
[some code]
end if
I am trying to extract querystring values from a htmldocument. It contains a number of anchor links with a querystring parameter called id. I would like to get all the ids in a commaseperated string. How can I fix this? So I would like to get: Result = {1,2,3,4,5}
[Code]....
I need to find rows in resultsets that have every column without null.these resultsets got variable number of columns.currently, the only way that I can think of is creating a view on each resultset and filter this way:
select field1, field2, field3, field4, ...
from "huge query"
where field1 is not null and
field2 is not null and
[code]....
and then in a storeproc/function or .net code(c# / vb.net) loop through all rows / columns and flag or remove every row that got any null?
Is there a way in LINQ to Entities (SQL) to identify all records where a specified word is repeated at least/less than a specified number of times?
I can do this in memory, looking for at least 3 instances of the word "word" using:
Where(Function(x) x.Description.Split("word").Count > 3)
However the Split() function cannot translate to a SQL equivalent, and so this can only be executed in-memory, which is excruciatingly slow by the time any number of records are involved.
The SQL to do this would be something like
WHERE Description LIKE '%word%word%word%'
And that's as far as I get - I can't work out how to get that SQL generated by LINQ to Entities. I tried the ugly hacky .Where(Function(x) x.Description.Contains("word%word%word") on the off chance, but I'm almost relieved that it doesn't work!
I need to know the IOCTL constants for the various strings (for example the value of the constant of IOCTL_ATA_PASS_THROUGH). Searching the net I found that those constants are defined in the header Ntddscsi.h but those constant are wrong. For example the constant value of IOCTL_ATA_PASS_THROUGH should be 4D02C while in the header file it is 40B
The question is: where can I find a list with ALL the right values?
I've found [URL].. where there are listed all the codes. the value in Ntddscsi.h is not the "final" value
I have the following setup[code]...
What I would like is a Item property in the collection that I can say [code]...
I know about predicates but what I am struggling with is how to set the criteria of the predicate (i.e passing x,y,z)
I need a source for the VALUES of the constants used for dealing with video using SendMessage.
View 11 RepliesI have been searching everywhere to figure out how to access the G-Sensor/Accelerometer in my HTC Touch Pro and other like devices. I've already created a number of app's for windows mobile but now I'd like to add some more customizations into my app's. I don't mind installing 3rd party app's but I'd like to add the same fuctionality into my own apps with regaurds to the G-Sensor/Accelerometer funtions. I got a hold of some code(Rhaakmeester)...
[code]...
This code helped a bit but only detects the change after a 3rd party app has already changed the screen orientation or if the KB was slid out. How do I access the G-Sensor data myself.
Find common values in multiple arrays with PHP Pretty much does what I need, but in PHP, I need VB. My situation is I am trying to create an intelligent stock pick system based on multiple stock locations. At the point of invoicing, we loop through the items invoiced and check the stock database for available stock.
If all items on the invoice are available to pick from stock location 1, then all should be picked from stock location 1... etc. If all most items are available from stock location 1 except one or two, then pick all stock from stock location 1 except for the exceptions which should be picked from the location with the highest available stock. Finding highest available stock is simple, but I can't work out how to analyse the stock availability from multiple locations and finding the common stock locations.
[Code]...
How to find a matching pair of values in two different arrays? Here's the scenario:
Index Array1 Array2
0 1 3
1 2 5
[code].....
I have a table called tblComparison - this table has the following columns[code]...
Once the averages for each column are created it needs to save them to tblMonthlyComparison - again the column names in this table are the same so in the fldDate column the program needs to enter 31/12/2011. In fldAverage of this table what we do is take the average that we found above for each column then plus them together and divide them by 5.
I've got a chart showing data as a part of a vb.net forms application. The Chart object makes a really pretty picture, but I need it to match the color scheme on the rest of the UI. How do I get the RGB values for the palette?
View 2 RepliesI have a table with the below structure.
ID VALUE
1 3.2
2 NULL
4 NULL
5 NULL
7 NULL
10 1.8
11 NULL
12 3.2
15 4.7
17 NULL
22 NULL
24 NULL
25 NULL
27 NULL
28 7
I would like to get the max count of consecutive null values in the table.
Having a bit of trouble using the List.Find with a custom predicate i have a function that does this
[code]...
by doing it this way means i have to have a shared "currentKey" object in the class, and i know there has to be a way to pass in the values i'm interested in of CurrentKey (namely, keyname, and oldkey) ideally i'd like to call it by something like keys.Find(AddressOf FindByOldKeyAndName(Name,OldVal))however when i do this i get compiler errors.How do i call this method and pass in the values?
Basically, I have an array of data with about 1000-2000 data points that form a rough Poisson distribution. What I need to do is take the maximum value of the distribution (which I know), and find the leftmost and rightmost values that are, say, 70% of the maximum. (I don't really care what the value of these numbers are. I want to know what index position they are in.) I then want to find the centerpoint between these two indices, rounding if necessary, and return all three values (left, right, and center).
View 2 Replies