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

 Title SQL Random Line Description: Returns a SQL random line Hits: 1846 Since 25th November, 2003 Code: Select and Copy the Code Function SQLRandomLines(proc, params, fname, count) Dim i, j, k, rid, rs, result, records, reccount, normalized On Error Resume Next PushError SQLRandomLines = 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) If CheckPopError Then Exit Function End If rid = -1 For i = 0 To rs.Fields.Count - 1 If (rs.Fields(i).Name = fname) Then rid = i End If Next If (rid < 0) Or (rid > rs.Fields.Count - 1) Then rid = -1 End If rs.Close Set rs = Nothing If (rid = -1) Then Exit Function End If reccount = UBound(records, 2) - LBound(records, 2) + 1 If (reccount >= count) Then normalized = RandomArray(count, LBound(records, 2), UBound(records, 2)) For i = LBound(normalized) To UBound(normalized) normalized(i) = records(rid, normalized(i)) Next Else normalized = RandomArray(reccount, LBound(records, 2), UBound(records, 2)) For i = LBound(normalized) To UBound(normalized) normalized(i) = records(rid, normalized(i)) Next End If ReDim result(UBound(records, 1), UBound(normalized)) For k = LBound(records, 2) To UBound(records, 2) For i = LBound(normalized) To UBound(normalized) If (CStr(records(rid, k)) = CStr(normalized(i))) Then For j = LBound(records, 1) To UBound(records, 1) If (TypeName(records(j, k)) = "String") Then result(j, i) = VarTrimStr(records(j, k)) Else result(j, i) = records(j, k) End If Next End If Next Next SQLRandomLines = result End Function

ASP Home | C Home | C++ Home | COBOL Home | Java Home | Pascal Home