Search:
Type: Posts; User: smendoza
Search:
Search took 0.03 seconds.
-
I think you need to declare your exit handlers inside of the transaction. Declare them after the start transaction declaration, currently they're declared before you declare the start transaction....
-
-
nm I read the question wrong and I can't delete my pointless post.
-
If I recall it's because you have a constraint in your database already called "IDS" try changing the name of the constraints name to something on than "IDS"
-
Or something like this.
String myString = "{Hello}{Bye}{Ouch}";
myString = myString.replace("{", "");
String[] myStringArray = myString.split("}");
-
They changed it a bit from 2005 to 2008 Clicky here
-
You need to have "execute" permission for the sproc. Take a look at the link it will show you how to add your user to be able to execute the sproc.
...
-
I agree, the mssql query optimizer seems better that's just my opinion. At work we use both mysql and mssql, it comes down to have a good design and index. Our myssql server runs fast we don't have...
-
I'm going to guess and say you have some NULL values in the database, in that case you will want to use the COALESCE() function. The coalesce function returns whatever value you tell it to, for...
-
tg, even worse when you have another manager that likes to try to throw you under the bus to cover his own a$$.
-
add "explain extended" before you queries , this will tell you that the mysql optimizer is doing if you curious to see what it's doing. But I'm guessing the data set on your local pc is much smaller...
-
take a look at this post on the forum.
http://www.vbforums.com/showthread.php?761447-Get-a-single-cel-value-from-excel-into-a-textbox-vb-net
It should get you started on how to at least read a...
-
Because you didn't change the datetime to DATE.
select Convert(DATE,CONVERT(nvarchar(10),CURRENT_TIMESTAMP, 101))
-
Try this
select Convert(date,CONVERT(nvarchar(10),CURRENT_TIMESTAMP, 101))
you have datetime instead of date, that's why it's returning the time.
-
Do you want to delete the record where it meets your criteria or are you trying to alter the database schema?
-
Off topic but, what are your license fears?
-
I think you can use whatever version of their DB standard, enterprise, and I think express now? (think they have an express version) for development purposes.
...
-
Good eye TG, I didn't even notice that! :eek:
-
Does the table tblEmployers exists?
-
You can use having and count() like the way I did. I was looking to show a count of the results only display the ones whom have a count of one.
take a look here http://sqlfiddle.com/#!2/b654cd/1...
-
I was bored so I'll add to this old thread.. 73wpm with 8 mistakes
-
give this a try
select rl.RetailPct, rm.MenuID
from RestaurantLoc rl
join RestaurantMeal rm on rm.RestLocId = rl.RestLocID
where MenuID = 2657
group by rl.retailPct, rm.MenuID
having...
-
Here is my little test I used when I first started messing with Jackson
my class for the json data structure.
import java.math.BigDecimal;
import java.util.List;
import...
-
Yeah, I thought that too when first looked at the page. But yes, it does parse JSON strings. http://wiki.fasterxml.com/JacksonInFiveMinutes
-
I use jackson https://github.com/FasterXML/jackson-core I've never tried it for Android dev though.
-
Check the Java docs http://docs.oracle.com/javase/7/docs/api/java/util/Arrays.html
String a = "a" per the java docs is returning the hashcode for the string object.
array.hashCode() per the...
-
the vpn I use isn't that slow, 6MB downstream and around 5MB up. It's $30 something a year, works like a charm and is not slow.
-
-
What about doing the silent install then restoring a backup of the blank database?
-
Are you attaching the database through your app or SSMS?
-
You're only attaching the database one time correct? or are you using the attachDbFileName each time you run your program?
-
lol I feel you're anti Java Shaggy, It's okay this a vbforum.
-
It's really what you're use to. There was a bit of learning curve when I started using Eclipse, then I got use to it.
-
select distinct(fp.studentid), fg.feegroupname
from feeGroups as fg inner join feeTypes ft
on fg.feeGroupID = ft.feeGroupID
inner join feesPayment fp
on fp.feeTypeID = ft.feeTypeID
where...
-
Another way is using maps.
http://docs.oracle.com/javase/tutorial/collections/interfaces/map.html
public class MapTest {
public static void main(String args[]){
Map<Integer, Boolean>...
-
I wouldn't recommend access because the sql syntax is MS ACCESS syntax and I waste a lot of time looking the correct syntax. There are a few other reason but I don't feel like explaining them.
-
When you say network do you mean over LAN or WAN? If it's LAN, I'm assuming you allowed remote connections and the client pc had the correct driver installed too?
-
Here is a quick example I threw together.
Imports System.Data.SqlClient
Imports System.Data.Sql
Private Sub restoreDB()
Dim sqlCmd As New SqlCommand
Dim connstr As String =...
-
That wasn't what I mean. I meant after that line of code has been executed what are the results? But since TG said the connection hasn't been corrected my post doesn't really matter until that's been...
-
OHhh, I thought he changed to connection string to connect to master and was no getting a syntax error when trying restore the database.
|
Click Here to Expand Forum to Full Width
|