No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
currently unemployed
- Interests
- Aquariums, Music (Phish, Grateful Dead, Radiohead, Alt Country, Widespread Panic, Tool, Bluegrass, Jazz…
19 Posted Topics
 | Also you seem to be relying on the javascript semi-colon insertion "feature". the language does require semi-colons at the end of every statement. It's just that it will supply them for you if you omit them. This can cause bugs when it gets it wrong. they can be very hard … |
| | Re: Sql Serverce [QUOTE=suganzeni;550775]Hi to all I am working with Sql server ce for mobile application with vb.net. I want to crete a table before that i have to check weather the table exists or not. Also want to know about Object id in sql server and how to create it. Thanks and … |
 | I can see right off the bat that you are missing the closing curly brace for the function definition in the onload event handler of the body. Plus it is missing quotes. After i fix that i just get a pretty picture of an emerald boa. maybe its a tree … |
| | [QUOTE=forzadraco;592728]hyy... i hv aproblem.. iwant to make aplication thabt need some field database from other database(pg-sql) and want to copy it to other database(mysql). can that skrip make this happen auto copying...?[/QUOTE] sure....probably....kinda. You just need to read the data out of the source table in the old database and …  |
 | if they are all coming from a single table...call it testTable... then you would just say [CODE=SQL] SELECT location1, location2, location3 FROM testTable WHERE .... [/CODE] and then you can fill in whatever goes in the WHERE clause to get the result you want. In general you can list as … |
| | Hello, I am messing around with javascript. I am trying to create a function to which i can pass a constructor and recieve back an object. Kinda (read exactly) like the new keyword. call it a learning exercise. I have a working model but i don't like it. here it … |
| | This forum is for MySQL. an open source SQL server. This post belongs in the MS SQL forum. They will have your answer. But you could try sqlcmd if the command line doesn't scare you. It should be installed in the system path variable so you can access it from … |
| | [QUOTE=ShawnCplus;582644]Use the onclick attribute with a function along the lines of [code=Pseudocode] Function EnableRadioButtons ( array Elements ) For each Element in Elements Set Element Enabled [/code][/QUOTE] Or maybe something along the lines of [code=Pseudocode] Function EnableRadioButtons ( array Elements ) if (button of interest is checked) { For each … |
| | Cursors are slooowwwwwww. you can add the ON DELETE CASCADE option to the foreign key in the sale_detail and sale_address tables. This makes it so that whenever you delete an entry in the parent table, all dependent records are deleted in the child tables that are created with this option. … |
| | Give this a shot from within sqlcmd or osql.... [CODE] EXEC sp_addumpdevice 'DISK', 'MyBackupToFTPland', 'DirectoryYouCanFTPFrom\backup.bak' BACKUP DATABASE yourdatabase TO MyBackupToFTPLand [/CODE] Then you should be able to FTP it...assuming of course that SQL Server has write access to someplace that you have FTP read access too.... could get complicated. Check … |
| | Sounds like a bad design to me. I am not familiar with foxpro but i would say that it is stupid to have to download the whole data base for any look up. it defeats the point of having a server. you might as well have every work station keep … |
| | You want something like: [CODE] SELECT columnyouwant1,...,columnyouwantn, rowcount = COUNT(B.ForeignKey) FROM TableB AS B GROUPBY B.ForeignKey [/CODE] Load that into a temporary table. lets call it T. then you can select based on rowcount to handle the two cases differently. You may be able to do it in one query … |
| | Re: TABLE CREATION HELLOOOOOO THERREEEE!!!! IT SOUNDS LIKE YOU WANT SEPERATE TABLES IF THE COLUMNS ARE ALL LINKED TO EACH OTHER!!!! YOU SHOULD COME CLOSER SO WE DON"T HAVE TO YELL!!! |
| | First off, the only two tables that are in any sort of normal form are Students and Subjects. The others do not have a primary key. Secondly, you are repeating information from the StudentSubjects to ExamResults table. It seems to me that the StudentSubjects table is entirely redundent, further denormalizing … |
| | I think you want to introduce a third table. [CODE] CREATE TABLE Moves ( MoveID int IDENTITY NOT NULL PRIMARY KEY, Date datetime NOT NULL ) CREATE TABLE Items ( ItemID int IDENTITY NOT NULL PRIMARY KEY, ItemDescription varchar(30) NOT NULL, ) CREATE TABLE ItemsOnMove ( ItemsOnMoveID int IDENTITY NOT … |
| | Hello, I am new to SQL. I assume that this is very simple. I have had trouble understanding the relevant example in the BOL as my installation (Express edition) does not seem to have the adventureworks database that is so ubiquitous in the examples. Say I have two tables, Test1 … |
| | Hi, I am new to VB. I am trying to parse an html file. I would like not to use a [code=VB.NET] WebBrowser [/code] control because it seems like overkill. The [code=VB.NET] HtmlDocument [/code] class appears not to work outside of a [code=VB.NET] WebBrowser [/code] control. If there is not … |
| | Hello All, I have a user define class, [code=vb] <Serializable()> Public Class City Public Name As String = "" Public State As String = "" Public URL As String = "" Public Sub New(ByVal state As String, ByVal name As String, ByVal url As String) me.State = state me.Name = … |
| | Hi, I am new to VB. I am trying to parse an html file. I would like not to use a WebBrowser control because it seems like overkill. The HtmlDocument class appears not to work outside of a WebBrowser control. If there is not a way to initialize it independantly, … |
The End.