Vyom World.com Let's Touch the Sky Together!
 Home VyomWorld.com Home Free Magazines! VyomLinks.com Home JobsAssist.com Home Vyom Network Contact Us Jobs & Careers Resume Submitter Placement Papers IT Companies Directory Computer Jobs Interview Questions Online Exams Vyom Career eMag. Fun Screensavers New! Send FREE SMS! SMS Jokes Source Codes Library Source Codes Home ASP Source Codes C Source Codes C++ Source Codes COBOL Source Codes Java Source Codes Pascal Source Codes Submit Source Codes GATE GATE an Overview GATE Preparation Study Materal GRE GRE an Overview GRE Questions GRE Preparation GRE Universities TOEFL Preparation TOEFL Resources GMAT Preparation GMAT Resources MBA Preparation MBA Resources Networking Concepts Networking Concepts Testing Preparation Testing Resources Webmasters Free Traffic Builder Webmaster Articles Web Hosting Tutorials Hardware Tutorial 1500 Free eBooks New! FREE Publications
Vyom Career eMag.
 Get 9,000+ Interview Questions & Answers in an eBook. 9,000+ Interview Questions All Questions Answered 5 FREE Bonuses Free Upgrades Get it now!
Get 9,000+ Interview Questions with Answers in an eBook

Home >> Source Codes Library Home >> Language Home >> Category Home > > Item Description
Search Code Library

 Advertisements Advertisements

 Title SQL Random ID Description: Returns a random SQL ID Hits: 2218 Since 25th November, 2003 Code: Select and Copy the Code Function SQLRandomIDs(proc, params, fname, count) Dim i, rs, records, reccount, normalized On Error Resume Next PushError SQLRandomIDs = Null Set rs = iOpen(proc, params) If CheckPopError Then Exit Function End If If rs.EOF Then rs.Close Set rs = Nothing Exit Function End If records = rs.GetRows(adGetRowsRest, , fname) If CheckPopError Then Exit Function End If rs.Close Set rs = Nothing reccount = UBound(records, 2) - LBound(records, 2) + 1 If IsNull(count) Or IsEmpty(count) Then count = reccount ElseIf (count < 0) Then count = reccount End If If (reccount >= count) Then normalized = RandomArray(count, LBound(records, 2), UBound(records, 2)) For i = LBound(normalized) To UBound(normalized) normalized(i) = records(0, normalized(i)) Next Else normalized = RandomArray(reccount, LBound(records, 2), UBound(records, 2)) For i = LBound(normalized) To UBound(normalized) normalized(i) = records(0, normalized(i)) Next End If SQLRandomIDs = normalized End Function
New! Click here to Add your Code!

ASP Home | C Home | C++ Home | COBOL Home | Java Home | Pascal Home
Source Codes Home Page

Recently Updated: New Placement Papers added.
Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Programming & Source Codes | GRE Preparation | Jobs, Discussions | Software Listing | Free eBooks | Free eBooks | Free Business Info | Interview Questions | Free Tutorials | International Business Information | IAS Preparation | Jokes, Songs, Fun | Free Classifieds | Free Recipes | FAQs | Free Downloads | Bangalore Info | Tech Solutions | Project Outsourcing, Web Hosting | GATE Preparation | MBA Preparation | SAP Info | Excellent Mobiles | Software Testing | Interview Questions | Freshers Jobs | Server Insiders | File Extension Directory

Copyright ©2003-2018 Vyom Technosoft Pvt. Ltd., All Rights Reserved. Read our Privacy Policy