Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 45
Search took 0.01 seconds.
Search: Posts Made By: MichaelTJ
Forum: SQL Language January 12th, 2004, 09:57 PM
Replies: 4
Views: 1,823
Posted By MichaelTJ
Thanks again Jeff, I found it just as I...

Thanks again Jeff,
I found it just as I refreshed this page.
I used this:
CreatedDate < (GETDATE() - 30)
It seems to be working ok, but if my luck is as usual I have to change to DATEDIFF.. he he...
Forum: SQL Language January 12th, 2004, 08:35 PM
Replies: 4
Views: 1,823
Posted By MichaelTJ
Hi Jeff, Thanks for the quick reply! I need...

Hi Jeff,
Thanks for the quick reply!
I need the output to be all posts older than 30 days.

------------------------
All help is Good help!
Regards
Michael
Forum: SQL Language January 12th, 2004, 07:09 PM
Replies: 4
Views: 1,823
Posted By MichaelTJ
Date based query when date is nvarchar

Hi all,
I have a table that contains posts from a forum. I also have a query that shows different posts depending on what group is selected. The creadtedDate field in the table is nvarchar (I know,...
Forum: ASP.NET 1.0 and 1.1 Basics December 18th, 2003, 05:36 PM
Replies: 10
Views: 4,249
Posted By MichaelTJ
Cool.. this sounds like a thing I have to try....

Cool.. this sounds like a thing I have to try. Does this only depend upon your first SQL querry(databinding) then? I mean regarding the datarelation?

------------------------
All help is Good...
Forum: ASP.NET 1.0 and 1.1 Basics December 18th, 2003, 02:18 PM
Replies: 10
Views: 4,249
Posted By MichaelTJ
Well, peter. Regarding the datalist/grid. ...

Well, peter.
Regarding the datalist/grid.
What I'm doing on my page is this:
I have a table in SQL called GROUP and another called TEXT. In the page where I display the different postings(Listed...
Forum: ASP.NET 1.0 and 1.1 Basics December 18th, 2003, 02:06 PM
Replies: 3
Views: 2,779
Posted By MichaelTJ
You struck it right on the money as always...

You struck it right on the money as always Peter..

Thanks for another helpfull tip...

------------------------
All help is Good help!
Regards
Michael
Forum: .NET Web Services December 16th, 2003, 09:34 PM
Replies: 16
Views: 5,944
Posted By MichaelTJ
This last bit is a unique ID creator and a random...

This last bit is a unique ID creator and a random 4 digit password generator

'*******UNIQUE ID AND PWD GENERATOR in Globalvar.vb*************
Public Shared Function SMSID()
SMSID =...
Forum: .NET Web Services December 16th, 2003, 09:27 PM
Replies: 16
Views: 5,944
Posted By MichaelTJ
This here is to decode the string '*******TO...

This here is to decode the string
'*******TO DECODE THE STRING in Globalvar.vb*************
Public Shared Function URLDecode(ByVal strConvert)
Dim arySplit
Dim strHex
Dim strOutput
Dim i As...
Forum: .NET Web Services December 16th, 2003, 09:24 PM
Replies: 16
Views: 5,944
Posted By MichaelTJ
This here is a nice way to URL encode a string...

This here is a nice way to URL encode a string for use with sending SMS ++
'********URL ENCODE A STRING in Globalvar.vb******************
Public Shared Function URLEncode(ByVal strData As String)...
Forum: .NET Web Services December 16th, 2003, 09:18 PM
Replies: 16
Views: 5,944
Posted By MichaelTJ
This next part is to just execte an SQL command...

This next part is to just execte an SQL command like INSERT, DELETE, UPDATE....
'****************CODE TO EXECUTE SQL COMMANDS IN Globalvar.vb*************
Public Shared Function Execute(ByVal...
Forum: .NET Web Services December 16th, 2003, 09:13 PM
Replies: 16
Views: 5,944
Posted By MichaelTJ
This next bit I use to call up an SQL connection...

This next bit I use to call up an SQL connection on any page on my site.
'**************GETTING AN SQL CONNECTION*****************
Public Shared Function Connect() As SqlConnection
m_objConn = New...
Forum: .NET Web Services December 16th, 2003, 09:03 PM
Replies: 16
Views: 5,944
Posted By MichaelTJ
Just a little update from last time: My page...

Just a little update from last time:
My page globalvar.vb now contains a number of functions I call when needed in my pages. I'll post them here (Thay may be of use to somebody somewhere (I hope.....
Forum: ASP.NET 1.0 and 1.1 Basics December 16th, 2003, 08:54 PM
Replies: 3
Views: 2,779
Posted By MichaelTJ
Closing browser using a Button

Hi, all
I have a frameset (frameset.asp) with 3 frames in it Top.aspx, Left.aspx and main.aspx
When a user click a button in left.aspx I want to either terminate the session (logout),
or just...
Forum: ASP.NET 1.0 and 1.1 Basics December 15th, 2003, 10:48 PM
Replies: 10
Views: 4,249
Posted By MichaelTJ
Thanks Ahmed, It looks to be exactly what I...

Thanks Ahmed,
It looks to be exactly what I wanted!
I'll try it out now.


------------------------
All help is Good help!
Regards
Michael
Forum: ASP.NET 1.0 and 1.1 Basics December 15th, 2003, 07:55 PM
Replies: 10
Views: 4,249
Posted By MichaelTJ
Make multiple buttons

Hi all,
I just wondering if anybody knows a good way to generate multiple buttons in ASPX.
What I want to do is this:
I have an SQL table containing Groups, here I also have info about who made...
Forum: ASP.NET 1.0 and 1.1 Basics December 4th, 2003, 06:13 PM
Replies: 7
Views: 14,940
Posted By MichaelTJ
I found it at last. Thanks for the follow up...

I found it at last. Thanks for the follow up Peter, alwasy enspire me to look deeper with that signature of your's..

Here is the workin code for my problem (AT LAST, yuuhuuu)


*********Working...
Forum: ASP.NET 1.0 and 1.1 Basics December 3rd, 2003, 09:39 PM
Replies: 7
Views: 14,940
Posted By MichaelTJ
Hmmm.. Still can't figure it out. the...

Hmmm.. Still can't figure it out.
the System.Net.HttpWebRequest class looks like it just handles receiveing URL's. what I need is sending URL's with an Authorization CODE in the header of the sent...
Forum: ASP.NET 1.0 and 1.1 Basics December 3rd, 2003, 05:44 PM
Replies: 10
Views: 35,534
Posted By MichaelTJ
Have you just renamed a .ASP page to .ASPX? or ...

Have you just renamed a .ASP page to .ASPX?
or
Have you created an .ASPX file and then copied in .ASP code to it?

------------------------
All help is Good help!
Regards
Michael
Forum: ASP.NET 1.0 and 1.1 Basics December 3rd, 2003, 04:23 PM
Replies: 7
Views: 14,940
Posted By MichaelTJ
HttpURLConnection from Java to ASPX???

Hi all you out there,
I'm making a page to send SMS from WEB, I've got a script in Java on how to do it.
But I'm making it in ASPX.
The first things in the script was ok to convert, but I can't...
Forum: SQL Language November 19th, 2003, 11:37 PM
Replies: 6
Views: 1,579
Posted By MichaelTJ
Thanx for another helpfull tip Peter... I'm new...

Thanx for another helpfull tip Peter... I'm new (getting better) at ASP.NET. But still quite hopeless in SQL. **Thinking** Wonder how I actually make things work he hehe.
My tables as such a mess, I...
Forum: SQL Language November 17th, 2003, 11:28 PM
Replies: 6
Views: 1,579
Posted By MichaelTJ
Worked like a charm.... as always! If you...

Worked like a charm.... as always!

If you were around in Norway I'd buy you a beer..

btw. If you are interrested in some table layout give me a word and I'll post it for you. (An easy way to...
Forum: SQL Language November 17th, 2003, 10:23 PM
Replies: 6
Views: 1,579
Posted By MichaelTJ
This is the table with group members. I have one...

This is the table with group members. I have one table containing members info (MEMBERS) and on that contains groups info (GROUPS). This third is to keep track of what members are in what group.
...
Forum: SQL Language November 17th, 2003, 08:23 PM
Replies: 6
Views: 1,579
Posted By MichaelTJ
Need help SQL querry

I have a table called GroupMembers
This has 4 col's named GroupName, GroupLevel, PhoneNr and GroupType
Info like this:
**************TABLE GroupMembers Content********
Whole Country -- Level1 --...
Forum: SQL Language November 17th, 2003, 12:49 AM
Replies: 2
Views: 5,867
Posted By MichaelTJ
Sorry I could not respond sooner, my internet...

Sorry I could not respond sooner, my internet link has been down for a while.
Yes I'm storing it at string. I've unfortunently taken over a base with a couple 100K entries. And my predessesor left...
Forum: SQL Language November 11th, 2003, 03:05 PM
Replies: 2
Views: 5,867
Posted By MichaelTJ
Select Distinct Order by...

Hi,
I've tried to order a querry, but it keeps giving me a bug..
Here goes:

*********************CODE*********************************
Select Distinct right(left(ryCreatedDate,4),2) FROM RYKTE...
Showing results 1 to 25 of 45

 


All times are GMT -4. The time now is 03:03 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.