606 Posted Topics

Member Avatar for AdventureX
Member Avatar for veledrom

Stored procedure would be faster, it is able to take advantage of data caching. Also there would be no intermediary processing of the sql from the web server side. Also a stored procedure is much more maintainable than code, you don't want to have to recompile your code to change …

Member Avatar for veledrom
0
59
Member Avatar for Leandro-AL

I would suggest to do this in code rather than the database. Always store your dates in utc and don't worry about the timezone, then in the code do the conversion necessary.

Member Avatar for Leandro-AL
0
228
Member Avatar for jack54

how about show us the database schema, and your full sql select statement, and you don't need to post the html code, just the sql code

Member Avatar for jack54
0
106
Member Avatar for sfrider0

I'm assuming sendText is a textbox. You need to get the text not the textbox [code] sendText.Text [/code]

Member Avatar for ddanbe
0
168
Member Avatar for dnmoore

You have two of the same constructors Change this [code] public Degree(float degree) { temp = degree; scale = 'C'; } public Degree(float degree) { temp = degree; scale = 'F'; } [/code] Read what you are assigned "Four constructors: one for the number of degrees, one for the scale, …

Member Avatar for dnmoore
0
2K
Member Avatar for Rocket452

In the form properties set formborderstyle to fixed(there are a few fixed types) and you might want to set controlbox to false as well.

Member Avatar for Rocket452
0
59
Member Avatar for polo_coins

You can do it in the registry, not necessarily programmatically like you might want, but here is the link. [url]http://www.experts-exchange.com/Programming/Languages/CPP/Q_20794497.html[/url]

Member Avatar for polo_coins
0
166
Member Avatar for Tbusuk

Not sure if this what you are asking, but you'll need this at the top of the method signature [code] public boolean handleEvent(Event event) throws IOException { } [/code]

Member Avatar for dickersonka
0
121
Member Avatar for nitric0

You seem to be making things a little hard. Zero things out to start with, then if their choice is valid increment person, then record their choice, then do your calculations. Also remove your line of [code] person = choice1+ .... etc [/code] here's the gist of what you need …

Member Avatar for Alex Edwards
0
123
Member Avatar for addae

This seems like a homework question to me. How about you give it a shot and show us what you think are some use cases for it and we can elaborate.

Member Avatar for dickersonka
0
66
Member Avatar for Celt.Max

Do you have indexes on any of these columns? Also, consider revising to not search based upon text strings, you have the id's right there. Also what are you trying to select, you trying to select count on distinct textcodes? I don't get what you are asking, if you said …

Member Avatar for dickersonka
0
65
Member Avatar for wiesiek

The issue is because you are placing the constraints on the same table Think of it this way, if you remove a trip in the middle of the sequence, it will cause all other trips that are fk'd from it to be deleted as well do as the error message …

Member Avatar for wiesiek
0
147
Member Avatar for blade_costic

Its all a matter of what you perceive. Some prefere php, asp.net, jsp and the list goes on. Focus on plain html first, then move on to a programming language to incorporate with it once you feel comfortable.

Member Avatar for Narue
0
184
Member Avatar for agz86
Member Avatar for briandouglas

What is your query? Try executing the same query in query browser and you will have the same result as the webpage.

Member Avatar for dickersonka
0
77
Member Avatar for polo_coins

if you are doing it in code, make the method accept an enum value if you can do that, agree with lizr and validate what is passed in, might want to add an enum value of unknown to your list and use it if an enum isn't valid for the …

Member Avatar for polo_coins
0
78
Member Avatar for That Chick

not sure what you are calling the code from, but you could either use a stored procedure with aditm passed in or create a view and filter the results based upon aditm

Member Avatar for dickersonka
0
97
Member Avatar for oirfian

you might want to try submitting a sitemap in google analytics you might not be able to find it with just your name if that word is not one of them that is indexed from your page take a look at google analytics and it will show you whats going …

Member Avatar for Dani
0
116
Member Avatar for Rombosia

Here's the code I use without any problem when passing byte arrays back and forth from java to c# [code] //Assign these some values byte[] byteImage; string savePath; FileStream fileStream = new FileStream(savePath, FileMode.Create); //attempts to write file to local machine fileStream.Write(byteImage, 0, byteImage.Length); fileStream.Close(); [/code]

Member Avatar for Rombosia
0
176
Member Avatar for anithajoe

Take a look at this for dynamic variable names with xsl. [url]http://bytes.com/forum/thread758105.html[/url]

Member Avatar for anithajoe
0
116
Member Avatar for Thirusha

Read the connection string from a config file, then load the connection string at runtime

Member Avatar for dickersonka
0
81
Member Avatar for dsuslow

to number one and two add the id fields, looks like its vteqbase.eqflxideb then you can join them from the selects

Member Avatar for dickersonka
0
70
Member Avatar for anithajoe
Member Avatar for cosmicfool

First make sure the stored procedure does exist Second make sure the user specified in the connection has privileges to use it, if not log in as administrator and allow that user to access it you can log in through sql management studio as that user after you apply your …

Member Avatar for cosmicfool
0
147
Member Avatar for msundastud
Member Avatar for carrierd

could be a couple problems make sure your dns server is up, also just try to ping the dnsname from another computer if all that is good, then time to start checking iis open iis and click on your site, and then check bindings see if it is listening on …

Member Avatar for DimaYasny
0
82
Member Avatar for cardanadam

Might want to try pinging [code] System.Net.NetworkInformation.Ping [/code] [url]http://msdn.microsoft.com/en-us/library/system.net.networkinformation.ping(VS.80).aspx[/url]

Member Avatar for LizR
0
94
Member Avatar for mantoo

use a stored procedure that will accept parameters to insert into a table It sounds like you are doing inserts manually through code and you will be more subjected to sql injectection attacks

Member Avatar for mantoo
0
117
Member Avatar for isaackhazi

i would create a stored procedure with a cursor use this to get the table names [code] SELECT name FROM dbo.sysobjects WHERE xtype = 'U' [/code] and this dynamic sql to set key [code] exec('alter table ' + @tablename + ' ADD PRIMARY KEY(osd)'); [/code]

Member Avatar for isaackhazi
0
543
Member Avatar for Diamonddrake

Check and see if these are different args for you before the application.run [code] string[] args = Environment.GetCommandLineArgs(); [/code]

Member Avatar for Diamonddrake
0
220
Member Avatar for Poab9200

1. Add a do while loop [code] do{ // your code here }while(repeat == "y") [/code] 2. first part use [code] int num; bool isNumber = Int32.TryParse(intput, out num); if(isNumber) { //this means the user input a number } [/code] the second part [code] bool isLetter = Char.isLetter(repeat[0]); [/code]

Member Avatar for Poab9200
0
122
Member Avatar for Caniggia

Regardless of your education you still need experience. It does look better to have two degrees over the average college grad, but not better than a guy with one degree and one year of experience. Just the way the job market works, unfortunately at the time of graduation even :-(. …

Member Avatar for Denniz
0
140
Member Avatar for vuyiswamb

Username is already a property of the profile set to readonly, are you trying to add a property or use the current one? if you need to add a new property, change it to something else like loggedinuser

Member Avatar for vuyiswamb
0
90
Member Avatar for dickersonka

I am determining what method to call by using the runtime class. My problem is whenever I pass in a null object, obviously it will throw a null reference exception. How are you able to determine at runtime the class of a null object. Although its null i need to …

Member Avatar for dickersonka
0
1K
Member Avatar for ansari.wajid

you need to specify what column for the where and the =1 i have no clue what you are wanting there [code] select * from ( select vRefTable from mainmenu where iMenuId=58 ) where -- your column name here vFieldsName in (select vFieldsName from TableField where iMenuId=58 and bIsPrimary=1 and …

Member Avatar for dickersonka
0
121
Member Avatar for john93891@yahoo
Member Avatar for titico

I use dyndns as well for port 80 with no problems. Assuming apache is running and nothing else is consuming port 80 like iis, you probably do have a firewall issue. Turn off windows firewall or whatever you may have. Also check the router's incoming packets to see if they …

Member Avatar for dickersonka
0
161
Member Avatar for laxviji143
Member Avatar for EddySR

sure you are hitting the same database? also, is it a long running query? if so, might want up your limits

Member Avatar for EddySR
0
273
Member Avatar for umesh.daiya

mono incorporates the .net libraries into linux, it allows apache to use mono to host the asp.net pages either get it through the repositories or [url]www.mono-project.com[/url]

Member Avatar for dickersonka
0
53
Member Avatar for srs_grp

not really sure what you are meaning all characters will have an int value, and you can translate the int value back to a char you can use ascii(char) or char(ascii) [code] select ascii('q') -- returns 113 select char(113) -- returns 'q' [/code]

Member Avatar for dickersonka
0
94
Member Avatar for anuj_sharma

not sure what your table structure is like but something like this should work [code] select * from userlogins ul inner join userdetails ud on ul.USER_ID = ud.USER_ID [/code]

Member Avatar for Shanti C
0
71
Member Avatar for puja_suri

You can do it with ajax Msdn Site [url]http://msdn.microsoft.com/en-us/magazine/cc164247.aspx[/url] Ajax Site [url]http://www.asp.net/ajax/ajaxcontroltoolkit/samples/modalpopup/modalpopup.aspx[/url]

Member Avatar for puja_suri
0
161
Member Avatar for Reliable

VNC is a good solution You can set it to where you can connect with no password, or with a password, but only from the person doing the logging in. You can then observe the desktop and interact if need be. [url]www.realvnc.com[/url] Remote desktop will not allow them to be …

Member Avatar for Reliable
0
189
Member Avatar for agz86

you posted this in the asp forum, but you are asking for sql how are you wanting to add dates? you can add dates together, but i don't really know what good that would do for you be more clear on what you want if you want to just add …

Member Avatar for udaybhoite
0
107
Member Avatar for NLCGraphics

there isn't an update into modify your update into personal_notes to just be update personal_notes

Member Avatar for NLCGraphics
0
578
Member Avatar for vuyiswamb

right click on the project and click set as startup project also might want to try restarting visual studio

Member Avatar for vuyiswamb
0
98
Member Avatar for leegeorg07

well depending upon what email provider you might be able to use an api or webservice call for example gmail [url]http://sourceforge.net/projects/gmail-api[/url] if not, then you might want to simulate the login and do screen scraping on the page that is returned

Member Avatar for leegeorg07
0
105
Member Avatar for ocbphoto

use DECIMAL you may not necessarily see it at first, but float uses a non exact number and decimal uses exact the currency symbol is just a matter of display, add it to your code side instead of db side

Member Avatar for ocbphoto
0
113

The End.