|
What I am trying to say is... If the textbox is empty, a null should be written to the database field. So, if I pass the null contained variable to the CreateParameter method, then I get errors. I want to test for nulls before I go to the database.
|
|
|
|
|
ok....
try isNull or isEmpty ...one of them should work! gosh, it's been a while since I used vb!
|
|
|
|
|
Lets say I have a textfield called txtTel. This is an optional field as the user doesn't have to enter a value. So if the nothing is entered I do a small test, something like:
Dim strTel
If Trim(Request.Form("txtTel")) = "" Then
strTel = Null
End If
Then I use this strTel value in my CreateParameter as a parameter. And because it is null, it doesn not work. It does work if if I make strTel = "".
Cheers
Brendan
|
|
|
|
|
can you just not include that parameter in your sql statement?
<br />
If Trim(Request.Form("txtDialCode")) = "" Then<br />
' do nothing<br />
Else<br />
objCmd.Parameters.Append objCmd.CreateParameter("@ContactDialCode", adWChar, adParamInput, Len(strDialCode), strDialCode)<br />
End If<br />
/jason
|
|
|
|
|
I want to create a perl script.
If we run perl script at the end of the day it should check which all users copied, moved or removed the files on the unix server (i.e. the script would be run on unix server). Suppose there r 10 users.
In short i want to know who all used the cp, mv or rm command at the end of the day.
Plz. let me know as soon as possible
Is it possible
|
|
|
|
|
Which shell are you using? I know with bash, as well with others, there is a history file of commands used by a specific user. It would be easy to write a script that would read that and then wipe it out when finished...assuming your shell has a history file, that is.
|
|
|
|
|
My boss would like make peer evaluations done on an electronic basis, he needs each employee to fill out a form like:
-your name "tom"- -person being evaluated's name "bob"-
q1 - response
q2 - response
ect...
The admin should then be able to do a search for "bob" and then a summary report will be made with the questsions asked and every ones responses about "bob"
q1 - "bill's response"
- "tom's response"
but none of the submitted reports should be accesible to other users besides the admin. So how can one submit something then not have access to it? i know its a simple problem but.... gah.. We are on a lan so right now i need to figure out how to keep the users out of a dir but allow them to submit to that dir.... any ideas?
|
|
|
|
|
Backend database with admin group and user group, where admin will have full access and users limited?
A web form with login for admin and users and dispaly summaries only for admin? Remember, when a user "submits", the page is processed on the server side and you can do a lot on the server!
There is more than one way to handle this...some of the others may have some suggestions too.
|
|
|
|
|
thanks guys, i think i've actually found out how to do it, since its on an intrAnet and not public access. I'ma using frontpage (srry... *crys*) to make a .asp page that will submit to a database and I will be using PHP to retrieve info for later reports.
|
|
|
|
|
Hi, all
I want some Design templet to develope web site to use it ...........
so plz send it to me...
samir vohra...
samir_i_vohra@yahoo.com
plz put subjetc line same...boss
|
|
|
|
|
No-one is going to send an email to an anonymous poster. If you don't care enough about this site to register, or even come back to read our replies, why would we bother ?
Your question doesn't make sense to me. What do you want, a design template to build a website in terms of the look and feel ? Using what language ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
You can google for template and free .
<italic>Work hard, Work effectively.
|
|
|
|
|
Can anyone recommend a commercial PDF server product?
Apologies for the re-post, first post was in wrong forum.
|
|
|
|
|
Hello all
I am redirect the user to the index page as he login but what I have to do is to redirect him to the same page plese help me
neeru
|
|
|
|
|
which page do u want him to redirect ?
i am not getting your question ..can u clarify a bit more ?
Abhijeet Jadhav
|
|
|
|
|
If you meant redirect him after login to the same page that he was in ?
Then use:
RedirectFromLoginPage(); Method in the Authentication class.
|
|
|
|
|
but i am working with asp not with .net
|
|
|
|
|
Will pay experienced programmer to teach me PHP/MySQL. I am a C++ programmer who needs minimal support.
Send brief resume and required hourly rate. We can start 1 hour at a time using Paypal.
I am particularly interested in building a real estate information form which in turn will propagate a MySQL database.
Jim Osborne
josborne@starband.net
|
|
|
|
|
If you remotely know C++, then you're wasting your money. Why do PHP anyhow, are you being forced to ? What's wrong with ASP.NET ? MySQL is pretty crappy too, although it's free for non commercial use, MSDE is just plain free, and kicks it's ass.
I recommend reviewing your architecture of choice, if you have a choice, and then buying some books and asking questions here.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I am using PHP/MySQL because it works well and is easy to learn. I need to get a real estate information system on-line ASAP. If I had the time and big bucks I would go with Coldfusion.
Years ago I used MS Sequel Server version 4 with C++. The code was difficult to maintain without ample training and due diligence. I heard MSDE is a much better database but then I have to go down the MS road again.
Thanks for your input.
sundownr
|
|
|
|
|
sundownr wrote:
I am using PHP/MySQL because it works well and is easy to learn.
So easy that you want to pay a tutor....
sundownr wrote:
If I had the time and big bucks I would go with Coldfusion.
What's wrong with doing it with ASP.NET/C# ? If you know C++, that would be a breeze for you.
sundownr wrote:
Years ago I used MS Sequel Server version 4 with C++. The code was difficult to maintain without ample training and due diligence.
The main problem would have been ADO. You think that using a crappy database will help you here ? I doubt it. Does PHP provide a dedicated layer to MySQL ? I doubt it would be as rich or useful as ADO.NET is.
sundownr wrote:
I heard MSDE is a much better database but then I have to go down the MS road again.
And that's bad because ? ASP.NET is simply the only viable choice for web development. PHP was good in it's day, but that day is long gone. ASP was and is a hack. J2EE is just too complex and hard to use. ASP.NET is totally killer, and really easy to learn to use, not to mention that the web abounds with info.
In all seriousness, I guarentee I could develop this site for you in C#/ASP.NET/MSDE much faster than anyone could do it in PHP using MySQL. I think you're making poor choices here, not least because your background in C++ actually empowers you to learn the best web development platform ( and it's totally free, unlike MySQL, which costs money in this case ( unless your real estate information system is theoretical or totally non-profit ).
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
If his server is Linux/Unix based, will the MS stuff even work?
------- sig starts
"I've heard some drivers saying, 'We're going too fast here...'. If you're not here to race, go the hell home - don't come here and grumble about going too fast. Why don't you tie a kerosene rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
John Simmons / outlaw programmer wrote:
If his server is Linux/Unix based, will the MS stuff even work?
OK, I'll admit that as he did not specify this, I assumed he was using Windows. I have no idea how far along Mono is, although I thought it was in a usable state, I would do serious research before trusting it. Obviously, there would be no MSDE support.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Christian Graus wrote:
ASP.NET is simply the only viable choice for web development. PHP was good in it's day, but that day is long gone.
Pffffffffffft...
Normally I wouldn't disagree with much of what you say in reagrds to programming...you've helped me countless times in C++...
However...that statement clearly suggests to me...you have no idea what your talking about when it comes to web development...
Anything you can do in ASP.NET I can do in PHP...not nateively maybe, but i'm sure there is a library or something written in PHP which allows you to do anything you can do in ASP.NET and in some cases better...
PHP so I understand, is the most popular scripting language around...and for good reason...perhaps the source I got that from was being biased...but IMHO...PHP seems to power most web sites...
PHP scripts are a dime a dozen....for anything you can think of...there are atleast a dozen scripts available ranging from "amatuer coder" to highly "skilled professional"...
PHP I would argue is just as fast in execution if not faster than ASP.NET by virtue of the fact it's OSS and has so many eyes looking at it making optimization changes and the Zend engine likely being written in C for a Linux system. I'm not sure how the two compare byte for byte but in all honesty how can a Windows system execute as quick as a cut down *nix machine running only the required software???
PHP lacks in some RAD/Development areas...like it's OOP support is poor, but that's ok...PHP5 is alot better...besides PHP usually attracts more experienced Linux developers...
There is a definite lack in quality IDE's...I still sometimes use VC++ 6.- IDE
Other than that IDE fact...I would still very much so prefer to use PHP...
BTW-Hosting is half the cost...
As for MySQL? You can use other databases...quit easily...however there are some mega major web sites (so I understand) which are currently using MySQL...so it can't be that bad...
Christian Graus wrote:
not to mention that the web abounds with info.
I don't think so...[^]
I think M$'s advertising is paying off...they've brain washed you
Cheers
It's frustrating being a genius and living the life of a moron!!!
|
|
|
|
|
Hockey wrote:
Normally I wouldn't disagree with much of what you say in reagrds to programming...
Hell, you're still entitled to an opinion, and you still are sure to know more than me in some areas.
Hockey wrote:
you have no idea what your talking about when it comes to web development...
I know as much as most people about ASP.NET, a little about asp, and I have only really glanced at PHP. Oh, and I've used J2EE. My comments are derived from the observation that no other platform I have seen supports OO and other methodologies that promote rapid development like ASP.NET does.
Hockey wrote:
Anything you can do in ASP.NET I can do in PHP...
Of course. My comments here aren't meant to suggest PHP can't create a site. Hell, we're all just generating HTML at the end of the day, right ? I'm talking about ease of use, ease of learning, and support for practices that promote easily maintained code.
Hockey wrote:
PHP seems to power most web sites...
Of course, because 'most' sites are written by people for their own use. Look instead at most big and/or commercial sites, and what do you find ? A lot of J2EE, a growing amount of ASP.NET, and some classic asp, for older sites ( like this one ).
Hockey wrote:
PHP I would argue is just as fast in execution if not faster than ASP.NET by virtue of the fact it's OSS and has so many eyes looking at it making optimization changes and the Zend engine likely being written in C for a Linux system. I'm not sure how the two compare byte for byte but in all honesty how can a Windows system execute as quick as a cut down *nix machine running only the required software???
You're talking about the speed of *nix vs Windows, this has nothing to do with PHP/ASP.NET. Mono will even this playing field, assuming such an advantage exists. REsponse times are fast enough that I care more about maintainable sites than fractions of a second.
Hockey wrote:
PHP lacks in some RAD/Development areas...like it's OOP support is poor, but that's ok...PHP5 is alot better...besides PHP usually attracts more experienced Linux developers...
This is my point, this is the reason I'd suggest that someone with a C++ background especially learn ASP.NET instead of trying to learn PHP.
Hockey wrote:
There is a definite lack in quality IDE's...I still sometimes use VC++ 6.- IDE
Yes, and I was talking about ease of learning/use.
Hockey wrote:
BTW-Hosting is half the cost...
I can get asp.net hosting for next to nothing. Who cares if I can save < $100 a year on hosting ? Equate that cost into the extra hours learning/writing in PHP.
Hockey wrote:
As for MySQL? You can use other databases...quit easily...however there are some mega major web sites (so I understand) which are currently using MySQL...so it can't be that bad...
When I looked into it, there was no stored procedure support, and it costs money most of the time, most people who use it are probably stealing it.
Hockey wrote:
I don't think so...[^]
LOL - well, I could argue quality of sites, but the truth is you probably won that one
Hockey wrote:
I think M$'s advertising is paying off...they've brain washed you
No, I just know more about the areas I focus on. I'm sure there are CP equivelants in PHP, but I've never seen them, because I don't use it, I use ASP.NET because I'd hate to have to write sites of the size that I work on without the support it gives me. Not because I can't, but because the better the tool, the easier it is to manage complexity.
Christian Graus - Microsoft MVP - C++
|
|
|
|